要按时间(先)和作者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
要按时间(先)和作者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