WHERe S.Sno=SC.Sno AND Cname!="数据结构"GROUP BY Sname HAVINg AV

学习时间:2026-10-01 09:02:49 阅读：346

WHERe S.Sno=SC.Sno AND Cname!="数据结构"GROUP BY Sname HAVINg AVG(Grade)>80里面的"S.Sno=SC.Sno 还有"GROUP BY Sname HAVINg AVG(Grade)>80

炙热的蜡烛

2026-10-01 09:02:49



这是计算机编程里的句子吧,应该关于是SQL查询的"S。Sno=SC。Sno "是指满足S。表下的SNO的值等于SC。表下SNO的值条件"GROUP BY Sname HAVINg AVG(Grade)>80是指满足平均成绩大于80条件的记录按照Sname列进行分组。