题解 | #某乎问答最大连续回答问题天数大于等于3天的用户及其对应等级#

select a.author_id,
       b.author_level,
       count(*) as day_cnt
from (select * , row_number() over(partition by author_id order by answer_date) as rn
      from answer_tb) a
left join author_tb b
on a.author_id = b.author_id
GROUP BY author_id , date_add(answer_date,INTERVAL -rn day)
having day_cnt >=3