SQL 查询

1.求各学院的学生人数
select deptno,count(*) from student group by deptno
2、查询学生表中男生女生各有多少人
select ssex,count(*) from student group by ssex
3、查询01院系的男生女生各多少
select ssex,count(*) from student where deptno='01' group by ssex
4.查询学生表各院系男生女生多少人
select deptno,ssex,count(*) from student group by deptno,ssex
5、查询score表中各个课程号及相应的选课人数
select cno,count(*)from score group by cno
6、查询score表中各个课程号及相应的选课人数，仅显示选修人数为2人及以上的数据
select cno,count(*)from score group by cno having count(*)>=2
7.查询score表中每个学生选修的各课程数
select sno,count(*)from score group by sno
8.查询score表中每个学生选修的各课程数和平均成绩
select sno,count(*),avg(grade)from score group by sno
9.查询score表中每个学生选修的各课程数大于或等于2门课程的学生平均成绩和选课门数
select sno,count(*),avg(grade) from score group by sno having count(*)>=2
10.查询学生表中前5条数据
select * from student limit 5
11、查询学生表第2-5条数据
select * from student limit 1,5