現在有三個表（如圖）。題目是:查詢平均分最高的課程資訊。
求一個mysql的代碼
uj5u.com熱心網友回復：
select avg(sc.Grade), c.cname from scinner join course as c on sc.cno = c.cno
group by sc.cno;
uj5u.com熱心網友回復：
樓上正確，不過可以考慮統計完成后再關聯學科表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
uj5u.com熱心網友回復：
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
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/18319.html
標籤：MySQL