# 180. 连续出现的数字
# https://leetcode-cn.com/problems/consecutive-numbers/

# SQL架构
Create table If Not Exists Logs (id int, num int);
Truncate table Logs;
insert into Logs (id, num) values ('1', '1');
insert into Logs (id, num) values ('2', '1');
insert into Logs (id, num) values ('3', '1');
insert into Logs (id, num) values ('4', '2');
insert into Logs (id, num) values ('5', '1');
insert into Logs (id, num) values ('6', '2');
insert into Logs (id, num) values ('7', '2');

# Write your MySQL query statement below
select
    distinct l1.num as ConsecutiveNums
from
    Logs l1,
    Logs l2,
    Logs l3
where
    l1.id = l2.id - 1
    and l2.id = l3.id - 1
    and l1.num = l2.num
    and l2.num = l3.num;

# clean-up
drop table Logs;