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;