题解 | 查询连续登陆的用户
查询连续登陆的用户
https://www.nowcoder.com/practice/9944210610ec417e94140ac09512a3f5
select user_id from ( select user_id, date_sub(date(log_time), interval rk day) as cnt_date from ( select a.user_id,log_time, row_number() over (partition by user_id order by log_time asc) as rk from register_tb a left join login_tb b using(user_id) ) t1 ) t2 group by user_id having count(1)>=3 order by user_id asc