mysql分类统计
SELECTcoalesce(public_institution.pub_id,'total'),teachers.is_leave,IFNULL(sum(sex='35'),0) AS `35`,IFNULL(sum(sex='36'),0) AS `36`FROMpublic_institutionLEFT JOIN teachers ON public_institution.pub_id = teachers.pub_id AND isnull(teachers.is_leave)