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

select t1.cust_id,t2.total_ordered
from Orders t1,
(select order_num,sum(quantity*item_price) total_ordered
from OrderItems
group by order_num) t2
where t1.order_num=t2.order_num
order by total_ordered desc