1
select studentId,count(score)'考试科目数量',
sum(score )'学生成绩',
avg(score)'学生平均成绩'
from result
where score>60
GROUP BY studentId
HAVING avg(score)>85
ORDER BY avg(score) desc;
1
select studentId,count(score)'考试科目数量',
sum(score )'学生成绩',
avg(score)'学生平均成绩'
from result
where score>60
GROUP BY studentId
HAVING avg(score)>85
ORDER BY avg(score) desc;