题解 | 最长连续登录天数

select user_id, max(cnt) as max_consec_days from(
    select user_id, date_add(fdate, interval -t_rk day) as first_date, count(*) over(
        partition by user_id, date_add(fdate, interval -t_rk day)
    ) as cnt 
    from(
        select fdate, user_id, row_number() over(
            partition by user_id
            order by fdate
        ) as t_rk
        from tb_dau
    ) as tb1
) as tb2
group by user_id