CREATE TABLE `score` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`courseId` int(11) NOT NULL COMMENT '课程编号',
`studentId` int(11) NOT NULL,
`result` float(5,2) NOT NULL COMMENT '成绩',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8
select courseId,avg(result) from score group by courseId
order by avg(result) desc limit 1;
select * from course where id=(
select courseId from score group by courseId
order by avg(result) desc limit 1
);course