WITH t1 AS( SELECT user_id, fdate, ROW_NUMBER() OVER(PARTITION BY user_id ORDER BY fdate) AS rn FROM tb_dau ), t2 AS( SELECT user_id, fdate, DATE_SUB(fdate, INTERVAL rn DAY) AS grp FROM t1 ), t3 AS( SELECT user_id, grp, COUNT(*) AS log_days FROM t2 GROUP BY user_i...