题解 | 最长连续登录天数

with t as(
select user_id,count(continue_day)as console_day
from(
select user_id,date_sub(fdate,interval row_number() over(partition by user_id)day) continue_day
from tb_dau
where  year(fdate)='2023' and month(fdate)='1'
) as tmp
group by user_id,continue_day
)
select user_id,max(console_day) max_consec_days
from t
group by user_id