1.select t3.部门名称，t2.人数 from (select t1.deptcode,count(t1.humancode) as 人数 from 员工表 t1 where humancode in (select humancode from 考核表 wherekpicode='合格') group by t1.deptcode) t2,部门表 t3where t2.deptcode=t3.deptcode2. select kpicode,count(*)as 人数 from 考核表 group by kpicode3.selectt3.deptname,t4.kpicode,t4.人数 from 部门...
