某網(wǎng)站包含兩個(gè)表，Customers 表和 Orders 表檩坚。編寫一個(gè) SQL 查詢不翩，找出所有從不訂購任何東西的客戶麦轰。
Customers 表：
+----+-------+
| Id | Name |
+----+-------+
| 1 | Joe |
| 2 | Henry |
| 3 | Sam |
| 4 | Max |
+----+-------+
Orders 表：
+----+------------+
| Id | CustomerId |
+----+------------+
| 1 | 3 |
| 2 | 1 |
+----+------------+
例如給定上述表格，你的查詢應(yīng)返回：
+-----------+
| Customers |
+-----------+
| Henry |
| Max |
+-----------+
答案：
select name customers from customers
where id not in (select CustomerId from Orders );
