错误的group by运用.sql

初学者

SELECT AVG(STU_SCORE) AS '班级成绩',CLASS_NAME AS '班级名',STU_NAME
FROM STUDENT INNER JOIN CLASS ON STUDENT.CLASS_ID=CLASS.CLASS_ID
GROUP BY CLASS_NAME/*查询个班级的平均成绩*/