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

select t1.l_user from(
    select 
            l.user_id as l_user, r.user_id as r_user, 
            row_number()over(partition by l.user_id order by date(l.log_time)) as rn
        from 
            login_tb l left join register_tb r
        on 
            l.user_id = r.user_id
        where 
            l.user_id = r.user_id
    )t1
where 
    t1.rn >= 3