题解 | #确定最佳顾客的另一种方式（二）#
确定最佳顾客的另一种方式（二）
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;
查看22道真题和解析
