refactor 1285

fishercoder1534 · fishercoder1534 · commit 39688143b200 · 2020-04-25T13:54:51.000-07:00
diff --git a/database/_1285.sql b/database/_1285.sql
@@ -1,49 +1,3 @@
---1285. Find the Start and End Number of Continuous Ranges
---
---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.
---
---# Write your MySQL query statement below
 select l1.log_id as start_id, min(l2.log_id) as end_id
 from
 (
