经典数据库查询操作

已知学生表(XS)、课程表(KC)、教师表(TC)、成绩表（XS_KC），各表的结构如下：

 

（1）查询选修课程‘3-105’且成绩在60到80之间的所有记录。

select*

from xs_kc

where cno = '3-105' and

      grade between 60 and 80;

（2）查询成绩为85、86或88的记录。

select*

from  xs_kc

where  grade = 85 or  grade = 86 or grade = 88;

（3）查询95031班的学生人数。

select count(class) as 人数

from xs

where class = 95031;

（4）查询至少有5名学生选修并以3开头的课程的平均成绩。

select avg(grade)

from xs_kc

where cno like '3%'

group by cno

having count(cno) >= 5;

（5）查询最低分大于70，最高分小于90的NO列。

select distinct no

from xs_kc

group by no

having min(grade) <= 70 and

       max(grade) <