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

select user_id from 
(select user_id,count(left(n_log_time,10)) cnt from 
(select user_id,log_time,date_sub(log_time,interval rn day) n_log_time from 
(select r.user_id,log_time,row_number()over(partition by r.user_id order by l.log_time)rn from  register_tb r
join login_tb l
on r.user_id=l.user_id)aa)bb
group by user_id)cc
where cnt>=3
order by user_id