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

# 代码逻辑同样适用于一个用户有多个订单的情况
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; 

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

相关推荐

评论
点赞
收藏
分享

创作者周榜

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