根睁敬据提示渗握来改，在GROUP BY后面加上Credit就OK 了
SELECT Cname 课丛早庆程名, Credit FROM SC JOIN Course ON SC.Cno = Course.Cno
GROUP BY Cname , Credit
HAVING AVG(grade)> 80
根据报错来改， 在GROUP BY后樱樱坦卜面加Credit就脊信丛🆗了
SELECT Cname 课程名, Credit FROM SC JOIN Course ON SC.Cno = Course.Cno
GROUP BY Cname , Credit
HAVING AVG(grade)> 80
连接是inner join on
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024