题解 | #某乎问答11月份日人均回答量#

select 
answer_date,
round(count(issue_id) / count(distinct author_id),2) per_num
from
answer_tb ab
group by answer_date
order by answer_date