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-04-01 15:04:26 首次发布