某网站包含两个表,Customers 表和 Orders 表。编写一个 SQL 查询,找出所有从不订购任何东西的客户。
Customers 表:
1 | Joe |
---|---|
2 | Henry |
3 | Sam |
4 | Max |
Orders 表:
Id | CustomerId |
---|---|
1 | 3 |
2 | 1 |
例如给定上述表格,你的查询应返回:
Customers |
---|
Henry |
Max |
解答
SELECT
Name as Customers
FROM Customers
WHERE Id NOT IN (
SELECT
DISTINCT CustomerId
FROM Orders
)
原题
来源:力扣(LeetCode)
链接:https://leetcode-cn.com/problems/customers-who-never-order