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

with tiaojian as (
select 
user_id,
date(log_time) as pday,
row_number()over(partition by user_id order by date(log_time) ) as py
from login_tb
),tiaojian1 as (
select 
user_id
from tiaojian 
group by user_id,subdate(pday,py)
having count(user_id)>=3
)


select 
rb.user_id
from register_tb rb inner join 
tiaojian1 t1 on rb.user_id=t1.user_id
where
reg_port<>"m"
order by rb.user_id