题解 | #确定最佳顾客的另一种方式(二)#
确定最佳顾客的另一种方式(二)
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
