MySql数据查询

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
);