题解 | #返回顾客名称和相关订单号#
返回顾客名称和相关订单号
https://www.nowcoder.com/practice/7e7bc361db6a4cb6aa35eefccfe75364
select cust_name,
(
select order_num FROM Orders AS b
WHERE b.cust_id = a.cust_id
) order_num
FROM Customers AS a
ORDER BY cust_name,order_num
select cust_name, order_num FROM Customers AS ct JOIN Orders AS od ON ct.cust_id = od.cust_id ORDER BY cust_name,order_num
查看9道真题和解析
投递字节跳动等公司10个岗位
