select     user_id,     MAX(counts) max_consec_days from     (         select             t2.user_id,             DATE_SUB (t2.fdate, INTERVAL t2.rk day) date1,             COUNT(1) as counts         from             (                 select                     t1.user_id,                     t1.fdate,                     row_number() over (                         partition by                             t1.user_id                         order by                             t1.fdate                     ) rk                 from                     (                         select DISTINCT                             user_id,                             fdate                         from                             tb_dau                     ) t1             ) t2         group by             t2.user_id,             DATE_SUB (t2.fdate, INTERVAL t2.rk day)     ) t3 group by     user_id;

40:00