三个表:Student(学生),Course(课程),SC(选课): 刚开始是这么写的: select Student.sname,Student.sno,avg(grade) as avg_grade from Student,SC where Student.sno=SC.Sno group by Student.Sno; 结果在SQL Server中执行报错: 我在网上查了很多,答案也都是这么写的,急的想摔电脑。 然鹅,在我深邃浩瀚的脑洞之下,我还是碰想出了答案:在group by后面可以有多个决定因素的,加上一个Student.sname就好了: select Student.sname,Student.sno,avg(grade) as avg_grade from Student,SC where Student.sno=SC.Sno group by Student.Sno,Student.sname; 或者 select Student.sname, SC.sno, avg(SC.grade) as avg_grade from dbo.SC inner join Student on SC.sno = Student.sno group by SC.sno, Student.sname 结果: 但如果做是题的话,就按刚开始写的那个就好了。