题解 | #某乎问答最大连续回答问题天数大于等于3天的#

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