1、查詢(xún)教師所有的單位即不重復(fù)的Depart列

select distinct depart from teacher

2、查詢(xún)Score表中成績(jī)?cè)?0到80之間的所有記錄

select * from score where degree between 60 and 80

3、查詢(xún)Score表中成績(jī)?yōu)?5，86或88的記錄

select * from score where degree in (85,86,88)

4、查詢(xún)Student表中“95031”班或性別為“女”的同學(xué)記錄

select * from student where class='95031' or ssex ='女'

5、以Cno升序、Degree降序查詢(xún)Score表的所有記錄

select * from score order by cno,degree desc

6、查詢(xún)“95031”班的學(xué)生人數(shù)

select count(*) from student where class='95031'

或者：select count(*) as scount from student where class='95031'  

---查詢(xún)結(jié)果另取列名 為scount 展示

7、查詢(xún)Score表中的最高分的學(xué)生學(xué)號(hào)和課程號(hào)

select sno,cno from score where degree=(select max(degree) from score) 

8、查詢(xún)每門(mén)課的平均成績(jī)

select cno,avg(degree) from score group by cno

9、查詢(xún)Score表中至少有5名學(xué)生選修的并以3開(kāi)頭的課程的平均分?jǐn)?shù)

select cno,avg(degree) from score group by cno having count(*)>=5 and cno like'3%'

10、查詢(xún)所有學(xué)生的Sname、Cno和Degree列

select sname,cno,degree from student,score

where student.sno=score.sno

或者：select sname,cno,degree from score join student on score.sno = student.sno

11、查詢(xún)所有學(xué)生的Sname、Cname和Degree列

select sname,cname,degree from student,course,score where student.sno = score.sno and score.cno=course.cno

或者：select sname,cname,degree from score join student on student.sno=score.sno join course on score.cno = course.cno