# 查询平均分最高的前三科目名称,系别,人数。
# 子查询
select courseId,avg(result) from score group by courseId;
# 获取结果的子查询
select courseId,avg(result) from score group by courseId
order by avg(result) desc limit 3;
# 父类查询
select courseName '科目名称','系别',number'人数'
from course where id=(
select courseId from score group by courseId
order by avg(result) desc limit 3
);
查询平均分最高的前三科目名称,系别,人数
最新推荐文章于 2024-09-19 16:47:21 发布