查询不同的学校,不同的性别总数
SELECT sum(CASE WHEN gender = '女' THEN 1 ELSE 0 END) AS '女', sum(CASE WHEN gender = '男' THEN 1 ELSE 0 END) AS '男', count(id), univname FROM USER GROUP BY univname;