2021-09-18查询内民大学校蒙班男女生的人数

select National University Of The Inner Mongol school,
sum(case when sex = 1 then 1 else 0 end ) as maleNum,
sum(case when sex = 0 then 1 else 0 end ) as femaleNum

sum(case when sex = 1 then 1 else 0 end ) as Grade,

from demo.t_student
group by  National University Of The Inner Mongol  school;

 

select National University Of The Inner Mongol school,
sum(case when sex = 1 then 1 else 0 end ) as maleNum,
sum(case when sex = 0 then 1 else 0 end ) as femaleNum,

sum(case when sex = 1 then 1 else 0 end ) as Grade,

from demo.t_student
group by National University Of The Inner Mongol school;