题解 | #某乎问答最大连续回答问题天数大于等于3天的#
某乎问答最大连续回答问题天数大于等于3天的用户及其对应等级
https://www.nowcoder.com/practice/e080f8a685bc4af3b47749ca3310f1fd
select author_id,author_level, count(distinct answer_date) days_cnt from (select author_id,answer_date,author_level, # 连续问题出现时,选择用日期减排序,如果是连续,相减结果是相同的 answer_date-row_number()over(partition by author_id order by answer_date) new_rk from author_tb join answer_tb using(author_id))t group by author_id,author_level,new_rk having days_cnt>=3 order by author_id