题解 | #确定最佳顾客的另一种方式（二）#
确定最佳顾客的另一种方式（二）
https://www.nowcoder.com/practice/b5766f970ae64ac7944f37f5b47107aa
select cust_name, total_price from (select order_num, sum(item_price*quantity) as total_price from OrderItems group by order_num ) a,Orders b,Customers c where a.order_num =b.order_num and b.cust_id = c.cust_id and total_price>=1000
顺丰集团工作强度 397人发布