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

相关推荐

像好涩一样好学:这公司我也拿过 基本明确周六加班 工资还凑活 另外下次镜头往上点儿
点赞 评论 收藏
分享
牛客网
牛客企业服务