数据库实验四 复杂查询

Student_20103322.o,GradeРfrom Student_20103322,SC_20103322Рwhere Student_20103322.Sno=SC_20103322.Sno ANDР Cno=(oР from Course_20103322Р ame='高数') AND Р Grade>ANYР (select GradeР from SC_20103322Р o='002')Рorder by Grade DESCР(11)检索选修3门以上课程的学生的学号、总成绩(不统计不及格的课程),并要求按总成绩的降序排列出来。Рselect Sno,SUM(Grade)Рfrom SC_20103322Рgroup by Sno Рhaving COUNT(Grade)>3 ANDРMIN(grade)>=60Рorder by SUM(Grade) DESCР(12)检索多于3名学生选修的并以3结尾的课程号的平均成绩。Рo,AVG(Grade) as '平均成绩'Рfrom SC_20103322Рgroup oРhaving COUNT(Sno)>3 AND РCno like '%3'Р(13)检索最高分与最低分之差大于5分的学生的学号、姓名、最高分、最底分。Рselect Sname,Student_20103322.Sno,MAX(Grade) '最高分', MIN(Grade) '最低分'Рfrom Student_20103322,SC_20103322Рgroup by Student_20103322.Sno,SC_20103322.Sno,Student_20103322.SnameРhaving Student_20103322.Sno=SC_20103322.Sno AND Р(MAX(Grade)-MIN(Grade))>5