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

select O.cust_id, T.total_price 
from 
(select order_num, sum(item_price*quantity) as total_price from OrderItems
group by order_num) AS T
INNER JOIN Orders O on T.order_num=O.order_num
order by T.total_price DESC;