题解 | 返回顾客名称和相关订单号以及每个订单的总价
返回顾客名称和相关订单号以及每个订单的总价
https://www.nowcoder.com/practice/4dda66e385c443d8a11570a70807d250
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
字节跳动公司福利 1371人发布