select answer_date,author_id,count(1) as answer_cnt

from answer_tb

group by answer_date,author_id

#where answer_cnt>=3  where需要在group by前面 如果放在啊后面需要用having

having answer_cnt>=3

order by answer_date,author_id