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

select user_id
from
(
    select user_id
    , count(date_sub(date_1,interval rn day)) num
    from 
    (
    select a.user_id
    , date(log_time) date_1
    , row_number()over(partition by user_id order by date(log_time)) rn
    from register_tb a left join login_tb b using(user_id)
    ) t1
    group by user_id
) t2
where num>=3