Question

用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(*) 人数 from table group by 系别,性别 order by 人数 desc

Answer 3

select count（*），dept,sex from student group by dept,sex order by count(*) desc