C# 第十一章上机练习1

--上机练习1
	SELECT SUM(ClassHour) AS 总学时数  FROM dbo.Subject GROUP BY GradeId ORDER BY SUM(ClassHour)
	
	SELECT StudentNo,AVG(StudentResult) AS 平均分 FROM dbo.Result GROUP BY StudentNo  ORDER BY AVG(StudentResult)
	
	SELECT SubjectId,AVG(StudentResult)AS 课程平均的 FROM dbo.Result GROUP BY SubjectId ORDER BY AVG(StudentResult) DESC
	
	SELECT StudentNo,SUM(StudentResult) AS 总分 FROM dbo.Result GROUP BY StudentNo ORDER BY SUM(StudentResult)