题解 | #确定最佳顾客的另一种方式（二）#
确定最佳顾客的另一种方式（二）
https://www.nowcoder.com/practice/b5766f970ae64ac7944f37f5b47107aa
select
cust_name
,sum(item_price*quantity) total_price
from OrderItems i,Orders o,Customers c
where i.order_num = o.order_num
and o.cust_id = c.cust_id
group by 1
having sum(item_price*quantity)>=1000
order by 2