;
insert into student values(0,'2024-02-25 10:10:10','王语嫣','123',
'15612345678',17,'女','慕容复,我和你不共戴天。'...',
sum(score) '科目总分',
count(score) '科目考试人数',
avg(score) '科目平均分'
from result
where studentId<4 # 基础筛选...group by testName # 分组操作
HAVING avg(score)>60 # 分组后筛选
ORDER BY avg(score) desc; # 根据平均分倒序排列