LeetCode Consecutive Numbers を解いてみた

問題

https://leetcode.com/problems/consecutive-numbers/

解いた

SELECT
    L.num AS 'ConsecutiveNums'
FROM
    Logs L,
    Logs LL,
    Logs LLL
WHERE
    L.id = LL.id - 1
    AND LL.id = LLL.id - 1
    AND L.num = LL.num && LL.num = LLL.num
GROUP BY
    L.num;

結果