查询平均分最高的科目名称以及所属院系与总人数?
SELECT courseId
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);
查询结果