# 1613. Find the Missing IDs

<https://leetcode.com/problems/find-the-missing-ids>

## Description

Table: `Customers`

```
+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| customer\_id   | int     |
| customer\_name | varchar |
+---------------+---------+
customer\_id is the primary key for this table.
Each row of this table contains the name and the id customer.
```

Write an SQL query to find the missing customer IDs. The missing IDs are ones that are not in the `Customers` table but are in the range between `1` and the **maximum** `customer_id` present in the table.

**Notice** that the maximum `customer_id` will not exceed `100`.

Return the result table ordered by `ids` in **ascending order**.

The query result format is in the following example.

```
Customers table:
+-------------+---------------+
| customer\_id | customer\_name |
+-------------+---------------+
| 1           | Alice         |
| 4           | Bob           |
| 5           | Charlie       |
+-------------+---------------+
Result table:
+-----+
| ids |
+-----+
| 2   |
| 3   |
+-----+
The maximum customer\_id present in the table is 5, so in the range [1,5], IDs 2 and 3 are missing from the table.
```

## ac

```java
```