题解 | 最长连续登录天数

#求取最大天数
select user_id,max(days) max_consec_days from 
(
#计数：连续日期天数
select user_id,count(1) days from 
(
#连续日期分组+排序
select 
user_id,
fdate,
row_number() over (partition by user_id order by fdate) rk,
fdate-row_number() over (partition by user_id order by fdate) date_group 
from tb_dau
) m
group by user_id,date_group
) n
group by user_id