- 有student表,按照班级,统计班级的总人数,男生人数和女生人数分别是多少。
-
- 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 class_id, SUM(sex = '男') AS male, SUM(sex = '女') AS female FROM student GROUP BY class_id
select 性别,count(性别) from student group by 性别