SELECT cust_id, SUM((SELECT SUM(quantity*item_price) # 新增SUM FROM OrderItems WHERE OrderItems.order_num = Orders.order_num)) AS total_ordered FROM Orders GROUP BY cust_id # 新增 ORDER BY total_ordered DESC; /* SELECT cust_id, (SELECT SUM(quantity*item_price) FRO...