题解 | 确定最佳顾客的另一种方式（二）

select C.cust_name,sum(OI.item_price*OI.quantity) total_price
from Customers C
join
Orders O
on C.cust_id = O.cust_id
join
OrderItems OI
on OI.order_num = O.order_num
group by C.cust_name
having sum(OI.item_price*OI.quantity) >= 1000
order by total_price