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

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

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

# SELECT cust_id, 
#         (SELECT SUM(quantity*item_price)
#         FROM OrderItems
#         WHERE OrderItems.order_num = Orders.order_num) as total_ordered
# FROM Orders
# Order by total_ordered DESC       

SELECT 
    o.cust_id cust_id,
    tb.total_ordered total_ordered
FROM (
    SELECT
        order_num,
        SUM(item_price * quantity) total_ordered
    FROM
        OrderItems
    GROUP BY
        order_num
    ) tb inner join
    Orders o
on
    tb.order_num = o.order_num
ORDER BY
    total_ordered DESC;

全部评论

相关推荐

牛舌:如果我不想去,不管对方给了多少,我一般都会说你们给得太低了。这样他们就会给下一个offer的人更高的薪资了。
点赞 评论 收藏
分享
点赞 收藏 评论
分享
牛客网
牛客企业服务