inner join语句
select studentId,count(score) '考试科目数量',
sum(score) '学生总成绩',
avg(score) '学生平均成绩'
from result inner join student
group by studentId;
select studentId,id,userName,testName,score,introduce
from result inner join student on result.studentId=student.id;