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

with
    log_tb_new as (
        select
            l.user_id as user_id,
            log_time as log_time,
            lag(l.log_time, 2) over (
                partition by
                    user_id
                order by
                    l.log_time asc
            ) as two_lines_before
        from login_tb l
            inner join register_tb r using (user_id) ##需要注意统计数据必须是在注册表的，所有是内连接
    )
select 
    distinct user_id
from
    log_tb_new
where 
    datediff(log_time,two_lines_before)=2