题解 | 最长连续登录天数

select user_id, max(consec_days) as max_consec_days
from (
    select user_id, rn, count(1) as consec_days
    from (
        select fdate, 
        user_id, 
        date_sub(fdate, interval row_number() over (partition by user_id order by fdate) day) as rn
        from tb_dau
    ) temp
    group by user_id, rn
) temp2
group by user_id