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

select a.author_id,author_level,days_cnt from (select author_id,count(distinct answer_date) days_cnt from answer_tb group by author_id) a join author_tb b on a.author_id=b.author_id where days_cnt>=3 order by a.author_id 想问下各位大佬，这样做有没有问题呀