求解SQL语句 - Java / Web 开发

学生信息表，如下：
  ID SEX SCORE YEAR
  1 男 88 2007
2 女 87 2008
3 男 89 2006
4 女 99 2009
5 男 54 2007
6 女 56 2008

要求统计出学生总人数，男生总人数，女生总人数
  小弟是在搞不定，求答案！谢谢

---

select count(*) from student;
select count(*) from student where sex='男';
select count(*) from student where sex='女';

---

SQL code:

select sex,count(*) from student group by sex
select count(*) as 总人数 from student


很难吗？？？

---

引用

select count(*) from student;
select count(*) from student where sex='男';
select count(*) from student where sex='女';

是采用一条语句展现出上面的统计结果 即： count（*），count(男)，count（女） 这样的效果

---

引用

SQL code

select sex,count(*) from student group by sex
select count(*) as 总人数 from student


很难吗？？？

不是用两条语句

---

select (select count(*) from student) as total,(select count(*) from student where sex='男') as mens,(select count(*) from student where sex='女') as womens from student;

---

引用

SQL code

select count(*) 总人数,
sum(case when sex=