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-09-09 21:14:24 发布