题解 | #确定最佳顾客的另一种方式（二）#
SELECT Customers.cust_name,SUM(item_price*quantity) AS total_price FROM Orders INNER JOIN OrderItems ON OrderItems.order_num=Orders.order_num INNER JOIN Customers ON Orders.cust_id=Customers.cust_id GROUP BY Customers.cust_name HAVING total_price>=1000 ORDER BY total_price;
