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

select user_id
from (
    select user_id,
    date_sub(log_date, interval row_number() over (partition by user_id order by log_date) day) dt_sub
    from (
        select distinct user_id,
        date_format(log_time,'%Y-%m-%d') log_date
        from login_tb l
        join register_tb r using (user_id)
    ) t1
) t2
group by user_id, dt_sub
having count(*)>=3
order by user_id