#查询平局分最高的前三科目名称,系别,人数
#子查询
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 in(
select courseId from score group by courseId
order by avg(result) desc
) limit 3;
DDL DML
最新推荐文章于 2024-09-21 11:30:16 发布