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

select lt.user_id 
from 
    login_tb as lt
where 
    exists (
        select 1 
        from login_tb as lt2
        where lt2.user_id=lt.user_id and datediff(lt2.log_time, lt.log_time)=1
    ) and 
    exists (
        select 1 
        from login_tb as lt3
        where lt3.user_id=lt.user_id and datediff(lt3.log_time, lt.log_time)=2
    ) and
    exists (
        select 1 from register_tb as rt
        where rt.user_id=lt.user_id
    )
order by 
    user_id