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

select
user_id
from (   
select 
user_id,date_flag,count(1) as time 
from 
(select
user_id, 
date_sub(log_date ,interval  rn day) as date_flag
from 
(select 
user_id,
log_date,
row_number() over(partition by user_id order by log_date asc ) as  rn
from 
(select
a.user_id as user_id ,
-- log_id,
date_format(log_time,"%y-%M-%d")  as log_date 
from 
login_tb a
join 
register_tb b
on a.user_id = b.user_id
group by a.user_id,date_format(log_time,"%y-%M-%d")
) t 
) t1
) t2
group by 
user_id,date_flag
) t3
where   time >2