题解 | #返回每个顾客不同订单的总金额#

SELECT cust_id,
(
    SELECT SUM(item_price*quantity)
    FROM OrderItems oi
    WHERE oi.order_num = o.order_num
    GROUP BY oi.order_num
) AS total_ordered
FROM Orders o
ORDER BY total_ordered DESC;