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

返回每个顾客不同订单的总金额

http://www.nowcoder.com/practice/ce313253a81c4947b20e801cd4da7894

SELECT a.cust_id,b.total_ordered FROM Orders a INNER JOIN (SELECT order_num,SUM(item_price*quantity) AS total_ordered FROM OrderItems GROUP BY order_num) b ON a.order_num=b.order_num ORDER BY total_ordered DESC;

全部评论

相关推荐

永泽one:厉害厉害,感觉我找第一份实习的时候就见过兄弟,威少头像印象挺深刻的
点赞 评论 收藏
分享
评论
13
2
分享

创作者周榜

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