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 月份