两个表查询以及分组排序与HAVING筛选

DQL语句

SELECT studentId '学号',userName '学生名称',
sum(score) '学生各科目总分',
count(score) '考试科目数量',
avg(score) '各科目平均分'
FROM result INNER JOIN student on result.studentId=student.id
#重新使用学号进行分组
GROUP BY studentId,userName
HAVING avg(score)>60
order by avg(score) desc;

#SELECT * FROM result INNER JOIN student ON result.studentId=student.id;

结果图