select userName,testName,score from result,student 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;
MySQL分组查询
最新推荐文章于 2024-05-19 03:18:57 发布