-- 构建排序，基于等差原理，来判断用户是否连续登录（这是核心) with tmp as ( select user_id, fdate, row_number() over ( partition by user_id order by fdate ) ranking from tb_dau where left(fdate, 7) = '2023-01' group by user_id, fdate ) select a.user_id, a.cnt_day max_consec_days from ( select user_id, date_sub(fdate,interval ra...
