Mysql查询实战

查询不同的学校，不同的性别总数

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;