# $1613. 找到遗失的ID
# https://leetcode-cn.com/problems/find-the-missing-ids/

# SQL架构
Create table If Not Exists Customers (customer_id int, customer_name varchar(20));
Truncate table Customers;
insert into Customers (customer_id, customer_name) values ('1', 'Alice');
insert into Customers (customer_id, customer_name) values ('4', 'Bob');
insert into Customers (customer_id, customer_name) values ('5', 'Charlie');

# Write your MySQL query statement below
with recursive tmp as ( 
    select 1 as n union all 
    select n + 1 from tmp where n <= 100 )
select n as ids from tmp
where n not in ( select customer_id from Customers )
and n <=( select max(customer_id) from Customers );

# clean-up
drop table Customers;