如何用SQL语句 按院系统计学生人数

Answer 1

select 系别,性别,count(*) 人数 from table group by 系别,性别 order by 人数 desc 上面语句不行的话： select * from (select 系别,性别,count(*) 人数 from table group by 系别,性别) order by 人数 desc

Answer 2

select 院系,count(学生) as 学生数 from 表 group by 院系