1 1.select Sname,Ssex,Class from Student 
 2 
 3 2.select distinct depart from Teacher 
 4 
 5 3.select * from Student
 6 
 7 4.select * from Score where Degree>=60 and Degree<=80
 8 select * from Score where Degree between 60 and 80
 9 
10 5.select * from Score where Degree in(85,86,88)
11 
12 6.select * from Student where Class = ‘95031‘ or Ssex = ‘女‘
13 
14 7.select * from Student order by Class desc
15 
16 8.select * from Score order by Cno,Degree desc
17 
18 9.select count(*) from Student where Class=‘95031‘
19 
20 10.select Cno,avg(Degree) from Score group by Cno
21 
22 11.select avg(Degree) from Score where Cno in (select Cno from Score group by Cno having count(*)>5) and Cno like ‘3%‘ group by Cno
23 select avg(Degree) from Score where Cno like ‘3%‘ group by Cno having count(*)>5
24 
25 12.select Sno from Score where Degree between 70 and 90
26 
27 13.select Sname,Cno,Degree from Score join Student on Student.Sno = Score.Sno
28 
29 14.select Sno,Cname,Degree from Score join Course on Score.Cno = Course.Cno
30 
31 15.select Sname,Cname,Degree from Score join Student on Student.Sno = Score.Sno join Course on Score.Cno = Course.Cno
32 
33 16.select avg(Degree) from Score where Sno in (select Sno from Student where Class = ‘95033‘)
34 
35 17.select Sno,Sname,Sbirthday from Student where YEAR(Sbirthday) = (select YEAR(Sbirthday) from Student where Sno = ‘108‘)
36 
37 18.select * from Score where Cno in(select Cno from Course where Tno =(select Tno from Teacher where Tname=‘张旭‘))
38 
39 19.SELECT degree FROM score,course WHERE score.cno=course.cno AND cname=‘计算机导论‘
40 
41 20.SELECT cname FROM teacher,course WHERE teacher.ton=course.tno AND tname=‘李诚‘
42 
43 21.SELECT depart FROM teacher,course WHERE teacher.ton=course.tno AND cname=‘高等数学‘
44 
45 22.select Tname from Teacher where Tno in(select Tno from Course where Cno in(select Cno from Score group by Cno having count(*) > 5))
46 
47 23.select * from Student where Class in(‘95031‘,‘95033‘)
48 
49 24.select distinct Cno from Score where Degree > 85
50 
51 25.select * from Score where Cno in(select Cno from Course where Tno in(select Tno from Teacher where depart = ‘计算机系‘))
52 
53 26.select Sname,Ssex,Sbirthday from Student union
54 select Tname,Tsex,Tbirthday from Teacher
55 
56 27.select Sname,Ssex,Sbirthday from Student where Ssex=‘女‘ union
57 select Tname,Tsex,Tbirthday from Teacher where Tsex=‘女‘
58 
59 28.select Tname,depart from Teacher where Tno in (select Tno from Course )
61  成绩表上：select Tname,depart from Teacher where Tno in(select Tno from Course where Cno in(select Cno from Score))
62 
63 29.select Tname,depart from Teacher where Tno in(select Tno from Course where Cno not in(select Cno from Score))
64 
65 30.select Class from Student where Ssex=‘男‘ group by Class having count(*)>1
66 
67 31.select * from Student where Sno not in(select Sno from Student where Sname like ‘王%‘)
68 
69 32.select Sname,YEAR(now())-YEAR(Sbirthday) from Student
70 
71 33.select max(Sbirthday) from Student union select min(Sbirthday) from Student
72 
73 34.select * from Student order by Class desc,Sbirthday
74 
75 35.select * from Teacher join Course on Teacher.Tno = Course.Tno where Teacher.Tsex=‘男‘
76 
77 36.select * from Score where Degree = (select max(Degree) from Score )
78 
79 37.select Sname from Student where Ssex = (select Ssex from Student where Sname=‘李军‘)
80 
81 38.select Sname from Student where Ssex = (select Ssex from Student where Sname=‘李军‘) and Class=(select Class from Student where Sname = ‘李军‘)
82 
83 39.select * from Score where Sno in(select Sno from Student where Ssex=‘男‘) and Cno in(select Cno from Course where Cname=‘计算机导论‘)