题解 | #返回顾客名称和相关订单号以及每个订单的总价#
返回顾客名称和相关订单号以及每个订单的总价
https://www.nowcoder.com/practice/4dda66e385c443d8a11570a70807d250
SELECT
c.cust_name,
o.order_num,
(
SELECT
SUM(item_price*quantity)
FROM
OrderItems os
WHERE
os.order_num = o.order_num
) AS OrderTotal
FROM
Customers c
LEFT JOIN Orders o ON o.cust_id = c.cust_id
ORDER BY
c.cust_name,
o.order_num;
#23届找工作求助阵地#
查看2道真题和解析
三奇智元机器人科技有限公司公司福利 88人发布