十一章 上机1

SELECT SUM(ClassHour) AS 课程数,GradeId AS 学期
FROM Subject
GROUP BY GradeId
ORDER BY SUM(ClassHour)

-------------------------------------------------------------------------
SELECT StudentNo AS 学号,AVG(StudentResult) AS 平均分
FROM Result
GROUP BY StudentNo

-------------------------------------------------------------------------
SELECT SubjectId AS 课程,AVG(StudentResult) AS 平均分
FROM Result
GROUP BY SubjectId
ORDER BY AVG(StudentResult) DESC

-------------------------------------------------------------------------
SELECT StudentNo AS 学号,SUM(StudentResult) AS 总分
FROM Result
GROUP BY StudentNo
ORDER BY SUM(StudentResult) DESC