# 183. 从不订购的客户
# https://leetcode-cn.com/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, customerId) values ('2', '1');

# Write your MySQL query statement below
select
    c.name as Customers
from
    Customers c
where
    c.id not in(
        select
            customerId
        from
            Orders
    );

# clean-up
drop table Customers;
drop table Orders;