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
);
04-28
12-09
38万+
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交