题解 | #确定最佳顾客的另一种方式（二）#
确定最佳顾客的另一种方式（二）
https://www.nowcoder.com/practice/b5766f970ae64ac7944f37f5b47107aa
select cust_name,sum(item_price*quantity) total_price from Customers t1 inner join Orders t2 on t1.cust_id=t2.cust_id inner join OrderItems t3 on t2.order_num=t3.order_num group by cust_name having total_price>=1000 order by total_price
投递腾讯等公司7个岗位 >