题解 | #确定最佳顾客的另一种方式(二)#
确定最佳顾客的另一种方式(二)
https://www.nowcoder.com/practice/b5766f970ae64ac7944f37f5b47107aa
SELECT c.cust_name, tb.total_price FROM ( SELECT order_num, SUM(item_price*quantity) AS total_price FROM OrderItems GROUP BY order_num HAVING total_price >= 1000) as tb INNER JOIN Orders as o ON tb.order_num = o.order_num INNER JOIN Customers as c ON o.cust_id = c.cust_id ORDER BY tb.total_price ASC;