compute by.sql

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

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