How do I write a query to get the first_name and last_name of customers having orders containing mor-CodePudding

Home > Software engineering > How do I write a query to get the first_name and last_name of customers having orders containing mor

How do I write a query to get the first_name and last_name of customers having orders containing mor

Time：07-10

How do I write a query to get the first_name and last_name of customers having orders containing more than 2 items?

CodePudding user response：

This should work:

SELECT 
s.first_name, s.last_name
 FROM sales_order s 
 JOIN sales_order_item so 
 ON so.fk_sales_order=s.id_sales_order
GROUP BY so.fk_sales_order
HAVING COUNT(*)>2

Page link：https//www.codepudding.com/Softwareengineering/470148.html

Prev:How do i get the first name from the customer_name column

Next:Combining two tables together twice and then pivot in MySQL

Tags：

mysql

sql

Links：
CodePudding