题解 | SQL必知必会 T100

select 
c.cust_name,
sum(oi.item_price*oi.quantity) total_price
from Orders o
inner join Customers c using(cust_id)
inner join OrderItems oi using(order_num)
group by 
 c.cust_name
 having total_price >=1000
order by total_price

1.groupby与having搭配

2.join与using搭配