select cust_id,sum(item_price*quantity) total_ordered from Orders left join OrderItems on Orders.order_num=OrderItems.order_num group by cust_id order by total_ordered desc;
1

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务