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

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