select answer_date,format(count((issue_id))*1.0/count(distinct(author_id)),2)  per_num from answer_tb 
where substring(DATE_FORMAT(answer_date,'%Y-%m-%d'),6,2) ='11'
group by answer_date