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;