mysql组函数count的具体用法:mysqlcount SELECT d.department,COUNT(CASE e.sex WHEN e.sex='f' AND p.position !='主管' THEN p.id END) fq,COUNT(CASE e.sex WHEN e.sex='f' AND p.position ='主管' THEN p.id END) fz,COU