连续出现的数字

编写一个 SQL 查询，查找Logs 表所有至少连续出现三次的数字。

+----+-----+
| Id | Num |
+----+-----+
| 1  |  1  |
| 2  |  1  |
| 3  |  1  |
| 4  |  2  |
| 5  |  1  |
| 6  |  2  |
| 7  |  2  |
+----+-----+

Code

SELECT distinct l1.num ConsecutiveNums
   FROM Logs l1
JOIN Logs l2
     ON l1.id=l2.id-1
JOIN Logs l3
     ON l1.id=l3.id-2
  WHERE l1.num=l2.num AND l2.num=l3.num;