# 1285. Find the Start and End Number of Continuous Ranges

https://leetcode.com/problems/find-the-start-and-end-number-of-continuous-ranges

## Description

Table: `Logs`

```

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| log\_id        | int     |
+---------------+---------+
id is the primary key for this table.
Each row of this table contains the ID in a log Table.
```

Since some IDs have been removed from `Logs`. Write an SQL query to find the start and end number of continuous ranges in table `Logs`.

Order the result table by `start_id`.

The query result format is in the following example:

```

Logs table:
+------------+
| log\_id     |
+------------+
| 1          |
| 2          |
| 3          |
| 7          |
| 8          |
| 10         |
+------------+

Result table:
+------------+--------------+
| start\_id   | end\_id       |
+------------+--------------+
| 1          | 3            |
| 7          | 8            |
| 10         | 10           |
+------------+--------------+
The result table should contain all ranges in table Logs.
From 1 to 3 is contained in the table.
From 4 to 6 is missing in the table
From 7 to 8 is contained in the table.
Number 9 is missing in the table.
Number 10 is contained in the table.
```

## ac

```java
```
