力扣刷题学习SQL篇——1-3 选择（从不订购的客户——使用not in）

1、题目

题目链接：https://leetcode.cn/problems/customers-who-never-order/
SQL架构

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
1
2
3
4
5
6
7
8
9