要按时间(先)和作者ID排序 升序

select answer_date,author_id,count(author_id) as answer_cnt
from answer_tb 
where month(answer_date)=11
group by author_id,answer_date
having count(author_id)>=3
order by answer_date,author_id