题解 | 最长连续登录天数

with t1 as(
select *,ROW_NUMBER () over(partition by user_id order by fdate) r
from tb_dau
where fdate between '2023-01-01' and '2023-01-31'
),
t2 as(
select user_id,date_sub(fdate,interval r day) 登录天数,count(*) 连续登录天数
from t1
group by user_id,登录天数
)
select user_id,max(连续登录天数) max_consec_days
from t2
group by user_id