统计各个班级的男女总人数

sql代码怎么写才能返回下面的数据啊，有没有人教教我啊，麻烦了

SELECT
c_name AS 班级,
SUM(CASE WHEN sex = 1 THEN 1 ELSE 0 END) AS 男,
SUM(CASE WHEN sex = 2 THEN 1 ELSE 0 END) AS 女,
COUNT(1) AS 总人数
FROM
stu
GROUP BY
c_name