SQL--上机一使用分组查询学生相关信息

--查询每个年级的总学时数,并按照升序排列SELECT gradeId,SUM(ClassHour)as 总学时FROM SubjectGROUP BY GradeIdorder by SUM(ClassHour) --查询每个参加考试的学员平均分SELECT StudentNo,AVG(StudentResult)as 平均分FROM Resultgroup by StudentNo--查询每门课程的平均分,并按照降序排列SELECT SubjectId,AVG(StudentResult) as 平均分FROM Resultgroup by SubjectIdorder by AVG(StudentResult) desc--查询每个学生参加的所有考试的总分,并按照降序排列SELECT StudentNo,SUM(StudentResult)as 总分FROM Resultgroup by StudentNoorder by SUM(StudentResult) desc