十一章连接,分组查询上机练习一

最新推荐文章于 2021-02-02 17:34:15 发布

qq_36074096

最新推荐文章于 2021-02-02 17:34:15 发布

阅读量1.1k

点赞数

分类专栏：初始JAVA

本文链接：https://blog.csdn.net/qq_36074096/article/details/53333732

版权

初始JAVA 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

--上机练习一
--NO.1
SELECT SUM(ClassHour) AS 总学时数 FROM  Subject GROUP BY Gradeid ORDER BY SUM(ClassHour) 
--NO.2
SELECT AVG(StudentResult) AS 平均分 FROM Result GROUP BY StudentNo ORDER BY AVG(StudentResult)
--NO.3
SELECT AVG(StudentResult) AS 平均分 FROM Result GROUP BY SubjectId ORDER BY AVG(StudentResult)
--NO.4
SELECT SUM(StudentResult) AS 总分 FROM Result GROUP BY StudentNo ORDER BY SUM(StudentResult) DESC