#子查询
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);
查询平均分最高的科目名称,系别,人数。
最新推荐文章于 2024-07-29 22:40:28 发布