select date(answer_date),author_id,
count(*) as answer_cut
from answer_tb
where substr(answer_date,1,7)='2021-11'
group by date(answer_date),author_id
having answer_cut>=3
order by date(answer_date),author_id

一遍过