select cust_id,(select sum(item_price*quantity) from OrderItems OI where OI.order_num = O.order_num) as total_ordered from Orders Oorder by total_ordered desc; 使用子查询