求助SQL Server语句出错求改正

如果在SELECT字句中使用聚合函数，比如SUM，MAX，MIN，AVG等。那么所有SELECT字句中的所有字段，要么在聚合函数中，要么在GROUP BY字句中。但是，你的COURSEID,COURSENAME,TEACHERID,TEACHERNAME字段就不满足上面的限制条件，这是报错的原因。

SELECT C.COURSEID,

      C.COURSENAME, 
                C.TEACHERID,
                C.TEACHERNAME,
                SUM(E.GRADE) AS COUNT 
 FROM EVALUATETEACHERGRADE E,
          COURSE C,
                GRADE G 
WHERE E.COURSEID=G.COURSEID    
      AND C.COURSEID=G.COURSEID 
        AND G.STUDENTID='0711001'
        AND C.COURSEID='100000'

GROUP BY C.COURSEID,

      C.COURSENAME, 
                C.TEACHERID,
                C.TEACHERNAME