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

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

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;

全部评论

相关推荐

牛客717484937号:双飞硕没实习挺要命的
点赞 评论 收藏
分享
求问:27届找Java开发实习学完微服务够用吗?
数开小菜鸡:没学完微服务都够了吧佬
点赞 评论 收藏
分享
点赞 收藏 评论
分享
牛客网
牛客企业服务