一凄鼻、題目
二腊瑟、個人思考
1)乍眼一看不難聚假,但是陷阱在答案還替換了表名,最基本的答案是按照題目的邏輯走:
select Customers.Name as Customers from Customers where Id not in (select distinct CustomerId from Orders);
2)表名的修改也可以這個樣子改
select Name Customers from Customers where id not in (select DISTINCT CustomerId from Orders);