compute by.sql

初学者

SELECT CLASS_NAME,STU_SCORE
FROM STUDENT INNER JOIN CLASS ON STUDENT.CLASS_ID=CLASS.CLASS_ID
WHERE STUDENT.CLASS_ID=CLASS.CLASS_ID
ORDER BY STUDENT.CLASS_ID
COMPUTE AVG(STU_SCORE) BY STUDENT.CLASS_ID