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

SELECT
    user_id
FROM
    (
        SELECT
            *,
            date_sub(DATE(log_time), INTERVAL rn DAY) as dt
        FROM
            (
                SELECT
                    *,
                    ROW_NUMBER() OVER (
                        partition by
                            user_id
                        order by
                            log_time
                    ) AS rn
                FROM
                    login_tb
                    JOIN register_tb USING (user_id)
            ) AS t1
    ) AS t2
GROUP BY
    user_id
HAVING
    COUNT(log_time) >= 3
ORDER BY
    user_id