select date(answer_date),
round(count(*)/count(distinct author_id),2) as per_num
from answer_tb
where substr(answer_date,1,7)='2021-11'
group by date(answer_date)

简单