某网站包含两个表,Customers 表和 Orders 表。编写一个 SQL 查询,找出所有从不订购任何东西的客户。

Customers 表:

1Joe
2Henry
3Sam
4Max

Orders 表:

IdCustomerId
13
21

例如给定上述表格,你的查询应返回:

Customers
Henry
Max

解答

1SELECT
2    Name as Customers
3FROM Customers
4WHERE Id NOT IN (
5    SELECT
6        DISTINCT CustomerId
7    FROM Orders
8)

原题

来源:力扣(LeetCode)
链接:https://leetcode-cn.com/problems/customers-who-never-order