with distinct_login as ( select fdate, user_id from tb_dau group by fdate, user_id ), rnk_diff as ( select *, date_sub(fdate,interval row_number() over (partition by user_id order by fdate) day ) as fix_date from distinct_login ), consecutive_login as ( select user_id, fix_date, count(1) as consecut...