select answer_date,round(count(issue_id)/count(distinct author_id),2) as per_num
from answer_tb
group by answer_date
order by answer_date asc
select answer_date,round(count(issue_id)/count(distinct author_id),2) as per_num
from answer_tb
group by answer_date
order by answer_date asc
牛客博客，记录你的成长
京公网安备 11010502036488号