#查询平均分最高的科目
#子查询
select courseId,avg(result) from score group by courseId;
#获取结果的查询
select courseId,avg(result) from score group by courseId
ORDER BY avg(result) desc limit 1;
#父类查询
select courseName'科目名称',department'系别',number'人数'
from course where id=(
select courseId from score GROUP BY courseId
ORDER BY avg(result)desc limit 1
);
MySQL数据查询-查询平均分最高的科目
于 2024-04-19 11:38:46 首次发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)