题解 | 查询连续登陆的用户

SELECT
    user_id
FROM
    (
        SELECT
            r.user_id,
            DATE (
                LEAD (log_time, 2, '1990-01-01') over (
                    PARTITION by
                        l.user_id
                    ORDER BY
                        l.log_time
                )
            ) AS next_2_time
        FROM
            register_tb as r
            JOIN login_tb as l ON r.user_id = l.user_id
    ) AS temp
WHERE
    next_2_time != '1990-01-01';

 -- 排除不合法的时间值