00:00:00

Description

Editorial

Customer ID Gap Detector

MEDIUM20 pts

A customer data platform receives account records from multiple systems.

Table: customers

customer_id: unique integer identifier for each customer
customer_name: display name for the customer

Task: Find all missing customer IDs in the integer range from 1 to the maximum customer_id currently present in the table.

Definition:

If max(customer_id) = M, evaluate every integer in [1, M].
Any integer in that range that is absent from customers.customer_id is considered missing.

Output requirements:

Return exactly one column named ids.
Sort result rows by ids in ascending order.

Notes:

customer_id is unique.
The maximum customer_id in any test case does not exceed 100.

Supported submission environments:

SQL (SQLite 3.27.2)
Pandas (Python)

Example

Input

customers:
| customer_id | customer_name |
|-------------|---------------|
| 1           | Alice         |
| 4           | Bob           |
| 5           | Charlie       |

Output

[
  {"ids":2},
  {"ids":3}
]

Explanation

The maximum ID is 5, so inspect [1, 5]. IDs 2 and 3 do not appear in customers and are therefore missing.

Example

Input

customers:
| customer_id | customer_name |
|-------------|---------------|
| 2           | Nia           |
| 3           | Omar          |
| 5           | Pia           |
| 9           | Quin          |

Output

[
  {"ids":1},
  {"ids":4},
  {"ids":6},
  {"ids":7},
  {"ids":8}
]

Explanation

The inspection range is [1, 9]. IDs present are {2,3,5,9}; the remaining IDs in range are missing.

Example

Input

customers:
| customer_id | customer_name |
|-------------|---------------|
| 1           | Ava           |
| 2           | Ben           |
| 3           | Cara          |
| 4           | Dan           |

Output

[]

Explanation

All IDs from 1 through max(customer_id)=4 are present, so there are no gaps.

Accepted0/0·0% Acceptance

Constraints

1 <= number of rows in customers <= 100
1 <= customer_id <= 100
customer_id is unique in customers
customer_name is a non-empty string
Maximum customer_id in each case is at most 100
Return exactly one column: ids
Sort by ids ascending
Use SQLite 3.27.2 semantics for SQL submissions
For Pandas submissions, return a DataFrame with exact column: ids

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

customers =

[{"customer_id":1,"customer_name":"Customer 1"},{"customer_id":4,"customer_name":"Customer 4"},{"customer_id":5,"customer_name":"Customer 5"}]

Loading problem...

101

00:00:00

Description

Editorial

Customer ID Gap Detector

MEDIUM20 pts

A customer data platform receives account records from multiple systems.

Table: customers

customer_id: unique integer identifier for each customer
customer_name: display name for the customer

Task: Find all missing customer IDs in the integer range from 1 to the maximum customer_id currently present in the table.

Definition:

If max(customer_id) = M, evaluate every integer in [1, M].
Any integer in that range that is absent from customers.customer_id is considered missing.

Output requirements:

Return exactly one column named ids.
Sort result rows by ids in ascending order.

Notes:

customer_id is unique.
The maximum customer_id in any test case does not exceed 100.

Supported submission environments:

SQL (SQLite 3.27.2)
Pandas (Python)

Example

Input

customers:
| customer_id | customer_name |
|-------------|---------------|
| 1           | Alice         |
| 4           | Bob           |
| 5           | Charlie       |

Output

[
  {"ids":2},
  {"ids":3}
]

Explanation

The maximum ID is 5, so inspect [1, 5]. IDs 2 and 3 do not appear in customers and are therefore missing.

Example

Input

customers:
| customer_id | customer_name |
|-------------|---------------|
| 2           | Nia           |
| 3           | Omar          |
| 5           | Pia           |
| 9           | Quin          |

Output

[
  {"ids":1},
  {"ids":4},
  {"ids":6},
  {"ids":7},
  {"ids":8}
]

Explanation

The inspection range is [1, 9]. IDs present are {2,3,5,9}; the remaining IDs in range are missing.

Example

Input

customers:
| customer_id | customer_name |
|-------------|---------------|
| 1           | Ava           |
| 2           | Ben           |
| 3           | Cara          |
| 4           | Dan           |

Output

[]

Explanation

All IDs from 1 through max(customer_id)=4 are present, so there are no gaps.

Accepted0/0·0% Acceptance

Constraints

1 <= number of rows in customers <= 100
1 <= customer_id <= 100
customer_id is unique in customers
customer_name is a non-empty string
Maximum customer_id in each case is at most 100
Return exactly one column: ids
Sort by ids ascending
Use SQLite 3.27.2 semantics for SQL submissions
For Pandas submissions, return a DataFrame with exact column: ids

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

customers =

[{"customer_id":1,"customer_name":"Customer 1"},{"customer_id":4,"customer_name":"Customer 4"},{"customer_id":5,"customer_name":"Customer 5"}]

Customer ID Gap Detector

Hints

Customer ID Gap Detector

Hints