题解 | 返回顾客名称和相关订单号以及每个订单的总价

# 代码逻辑同样适用于一个用户有多个订单的情况
SELECT c.cust_name, oi.order_num, SUM(oi.quantity * oi.item_price) AS OrderTotal
FROM Customers AS c
INNER JOIN Orders AS o
ON c.cust_id = o.cust_id
INNER JOIN OrderItems AS oi
ON o.order_num = oi.order_num
GROUP BY c.cust_name, oi.order_num
ORDER BY c.cust_name, oi.order_num; 

#牛客创作赏金赛#
全部评论

相关推荐

05-26 09:07
已编辑
门头沟学院 Java
点赞 评论 收藏
分享
双非阴暗爬行:我来看看笑死我了,这名字取得好想笑(没有不好的意思)
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客企业服务