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

SELECT cust_name,
o.order_num,
SUM(quantity*item_price)
AS OrderTotal
FROM Customers c
INNER JOIN Orders o
ON c.cust_id = o.cust_id
INNER JOIN OrderItems oi
ON o.order_num = oi.order_num
GROUP BY oi.order_num, cust_name
ORDER BY cust_name, o.order_num ASC;