Day23_LEETCODE_180. Consecutive Numbers.sql

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