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

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