错误的group by运用.sql

来自「初学者」· SQL 代码 · 共 3 行

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/*查询个班级的平均成绩*/