cube.sql

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

SELECT ISNULL(TEA_NAME,'班级成绩汇总'),ISNULL(CLASS_NAME,'汇总计算') ,avg(STU_SCORE)
FROM STUDENT INNER JOIN CLASS ON STUDENT.CLASS_ID=CLASS.CLASS_ID 
INNER JOIN TEA_STU ON STUDENT.STU_ID=TEA_STU.STU_ID INNER JOIN TEACHER ON TEA_STU.TEA_ID=TEACHER.TEA_ID
GROUP BY CLASS_NAME,TEA_NAME WITH CUBE