题解 | 最长连续登录天数
最长连续登录天数
https://www.nowcoder.com/practice/cb8bc687046e4d32ad38de62c48ad79b
with t as( select user_id,count(continue_day)as console_day from( select user_id,date_sub(fdate,interval row_number() over(partition by user_id)day) continue_day from tb_dau where year(fdate)='2023' and month(fdate)='1' ) as tmp group by user_id,continue_day ) select user_id,max(console_day) max_consec_days from t group by user_id
