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