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

select cust_id, total_price

from Orders a

join (select order_num, sum(item_price*quantity) total_price

from OrderItems group by order_num) b

on a.order_num = b.order_num

order by total_price desc;