题解 | 确定最佳顾客的另一种方式(二)
确定最佳顾客的另一种方式(二)
https://www.nowcoder.com/practice/b5766f970ae64ac7944f37f5b47107aa
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
查看11道真题和解析