180. Consecutive Numbers.sql

/* Write your PL/SQL query statement below */
SELECT DISTINCT L1.NUM AS CONSECUTIVENUMS
FROM LOGS L1
INNER JOIN LOGS L2
ON L1.ID=L2.ID-1
INNER JOIN LOGS L3
ON L2.ID=L3.ID-1
WHERE L1.NUM=L2.NUM AND L2.NUM=L3.NUM