--上机练习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)
C# 第十一章上机练习1
最新推荐文章于 2020-01-26 18:47:10 发布