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

SELECT
    khb.cust_name,
    ddb.order_num,
    SUM(spb.item_price * spb.quantity) AS OrderTotal
FROM Orders AS ddb
INNER JOIN Customers AS khb
    ON ddb.cust_id = khb.cust_id
INNER JOIN OrderItems AS spb
    ON ddb.order_num = spb.order_num
GROUP BY khb.cust_name,ddb.order_num
ORDER BY cust_name,OrderTotal