从不订购任何东西的客户

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

Customers 表：
+----+-------+
| Id | Name  |
+----+-------+
| 1  | Joe   |
| 2  | Henry |
| 3  | Sam   |
| 4  | Max   |
+----+-------+

Orders 表：
+----+------------+
| Id | CustomerId |
+----+------------+
| 1  | 3          |
| 2  | 1          |
+----+------------+


例如给定上述表格，你的查询应返回：

+-----------+
| Customers |
+-----------+
| Henry     |
| Max       |
+-----------+

#建表语句

CREATE TABLE IF NOT EXISTS Customers (Id INT, NAME VARCHAR(255));
CREATE TABLE IF NOT EXISTS Orders (Id INT,CustomerId INT);
TRUNCATE TABLE Customers;
INSERT INTO Customers (Id, NAME) VALUES('1', 'Joe');
INSERT INTO Customers (Id, NAME) VALUES('2', 'Henry');
INSERT INTO Customers (Id, NAME) VALUES('3', 'Sam');
INSERT INTO Customers (Id, NAME) VALUES('4', 'Max');
TRUNCATE TABLE Orders;
INSERT INTO Orders (Id, CustomerId) VALUES('1', '3');
INSERT INTO Orders (Id, CustomerId) VALUES('2', '1');

#答案

SELECT NAME
FROM customers c
WHERE c.id NOT IN (SELECT customerid FROM orders)

#展示