两个表的联合查询以及分组排序与HAVING语句

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;