select user_id,max(title_number) as max_consec_days
from
(
select user_id,title,count(*) as title_number
from
(
select user_id,fdate,date_sub(fdate,interval row_number()over(partition by user_id order by fdate) Day) as title
from
(
select distinct user_id,fdate from tb_dau
where month(fdate) = 1
) as t1
) as t2
group by user_id,title
) as t3
group by user_id