mysql基本查找编程求助

[Cosica]

现在有三个表（如图）。题目是:查询平均分最高的课程信息。
求一个mysql的代码

[带我飞的云]

select avg(sc.Grade), c.cname from sc
inner join course as c on sc.cno = c.cno
group by sc.cno;

[乐大师]

楼上正确，不过可以考虑统计完成后再关联学科表 select a.cname,b.avg_grade from course as b inner join (select avg(grade) as avg_grade, cno from sc group by cno) as b on a.cno=b.cno

[带我飞的云]

SELECT AVG(sc.Grade) AS avg_score, c.cname FROM sc
INNER JOIN course AS c ON sc.cno = c.cno
GROUP BY sc.cno
ORDER BY avg_score DESC LIMIT 1