题解 | 查询连续登陆的用户
查询连续登陆的用户
https://www.nowcoder.com/practice/9944210610ec417e94140ac09512a3f5
with a as (
select log_time, user_id,
date_sub(log_time, interval (row_number() over (partition by user_id order by log_time)) day) as start_day
from login_tb
)
select distinct a.user_id
from a
join register_tb as rt
on a.user_id = rt.user_id
group by a.user_id, a.start_day
having datediff(max(a.log_time), a.start_day) >= 3;
