题解 | 返回顾客名称和相关订单号以及每个订单的总价
# 代码逻辑同样适用于一个用户有多个订单的情况 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;#牛客创作赏金赛#
