统计汇总男生.女生的人数,请写出sql语句

select stuClass,count(stuName) 班级人数,sum(case when stuSex='男' then 1 else 0 end ) 男生人数,sum(case when stuSex='女' then 1 else 0 end ) 女生人数 from student group by stuClass

select

nv=(select count(*) from table where sex='女'),

nan=(select count(*) from table where sex='男')

from table

这样就可以分别统计男和女的数量了.

---