select userName,testName,score FROM students,result
where result.studentId=student.id;
#笛卡尔积
select userName,count(score) '参与考试数量',
avg(score) '每人平均分数',sum(score) '每人的总分'
from result,student
where result.studentId=student.id and score>60
GROUP BY userName;
#select testName,count(testName),sum(score),avg(score) from result GROUP BY testName;
select studentid,
count(studentid) '学生考试科目数量',
sum(score) '学生的总成绩',avg(score) '学生的平均分'
from result GROUP BY studentId;