# $1285. 找到连续区间的开始和结束数字
# https://leetcode-cn.com/problems/find-the-start-and-end-number-of-continuous-ranges/

# SQL架构
Create table If Not Exists Logs (log_id int);
Truncate table Logs;
insert into Logs (log_id) values ('1');
insert into Logs (log_id) values ('2');
insert into Logs (log_id) values ('3');
insert into Logs (log_id) values ('7');
insert into Logs (log_id) values ('8');
insert into Logs (log_id) values ('10');

# Write your MySQL query statement below
select
    min(log_id) as start_id,
    max(log_id) as end_id
from
    (
        select
            log_id,
            log_id - row_number() over() as diff
        from
            Logs
    ) tmp
group by
    tmp.diff;

# clean-up
drop table Logs;