十一章 上机1

SELECT SUM(ClassHour) AS 课程数,GradeId AS 学期FROM SubjectGROUP BY GradeIdORDER BY SUM(ClassHour)-------------------------------------------------------------------------SELECT StudentNo AS 学号,AVG(StudentResult) AS 平均分FROM ResultGROUP BY StudentNo-------------------------------------------------------------------------SELECT SubjectId AS 课程,AVG(StudentResult) AS 平均分FROM ResultGROUP BY SubjectIdORDER BY AVG(StudentResult) DESC-------------------------------------------------------------------------SELECT StudentNo AS 学号,SUM(StudentResult) AS 总分FROM ResultGROUP BY StudentNoORDER BY SUM(StudentResult) DESC