题解 | #最大连续回答问题天数大于等于3天的用户#
某乎问答最大连续回答问题天数大于等于3天的用户及其对应等级
https://www.nowcoder.com/practice/e080f8a685bc4af3b47749ca3310f1fd
with t1 as( select answer_date, author_id, dense_rank() over(partition by author_id order by answer_date) rn from answer_tb ) select author_id,author_level,max(days) days_cnt from( select author_id,count(distinct answer_date) days from t1 group by author_id,date_sub(answer_date,interval rn day) )t2 left join author_tb using(author_id) group by author_id,author_level having days_cnt >= 3