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

学习时间:2026-04-02 06:23:30 阅读：1571

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-04-02 06:23:30



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