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

select user_id
from (select *,date_sub(time,interval cum day) as base_time 
	  from (select *,row_number() over(partition by a.user_id order by a.time) as cum 
			from (select distinct user_id,date(log_time) as time from login_tb order by user_id	
				 )a
		   )b
	 )c 
where user_id in (select user_id from register_tb)
group by user_id 
having count(*)>=3
order by user_id;