SELECT answer_date,round(count(issue_id)/count(distinct author_id),2)as per_num
from answer_tb
where DATE_FORMAT(answer_date,"%Y-%m")="2021-11"
GROUP by answer_date
SELECT answer_date,round(count(issue_id)/count(distinct author_id),2)as per_num
from answer_tb
where DATE_FORMAT(answer_date,"%Y-%m")="2021-11"
GROUP by answer_date