sql 行转列实现

SELECT
	class_id,
	sum(
		CASE
		WHEN sex = '男' THEN
			1
		ELSE
			0
		END
	) AS '男',
	sum(
		CASE
		WHEN sex = '女' THEN
			1
		ELSE
			0
		END
	) AS '女'
FROM
	student
GROUP BY
	class_id;