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

select
    cust_id,
    sum(item_price * quantity) as total_ordered
from
    OrderItems
    inner join Orders on OrderItems.order_num = Orders.order_num
group by
    cust_id
order by
    total_ordered desc