select DATE_FORMAT(cn.rq, '%Y') 年份, DATE_FORMAT(cn.rq, '%m月') 月份, cn.DEPARTMENTNAME 部门, round((cn.cs)/(pn.rs),2) as 参与度 from (select count(A.departmentid) rs, B.departmentname, A.departmentid from hrmresource A LEFT JOIN hrmdepartment B on B.id = A.departmentid group by B.departmentname) pn, (select L.bm, B.DEPARTMENTNAME, count(bm) cs, DATE_FORMAT(L.rq, '%m月'),L.rq from uf_aqxwgctj L LEFT JOIN hrmdepartment B on B.id = L.bm group by B.DEPARTMENTNAME, DATE_FORMAT(L.rq, '%m月') order by DATE_FORMAT(L.rq, '%m月') ) cn where cn.rq like '${year}%' and cn.DEPARTMENTNAME in ('${bm}') group by cn.DEPARTMENTNAME,月份 order by 月份