相关子查询.sql

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

SELECT STU_NAME,STU_SCORE,CLASS_NAME,CLASS_SCORE=(SELECT AVG(STU_SCORE) FROM STUDENT AS S3 WHERE S1.CLASS_ID=S3.CLASS_ID) 
FROM STUDENT AS S1 INNER JOIN CLASS ON S1.CLASS_ID=CLASS.CLASS_ID
WHERE STU_SCORE>(SELECT AVG(STU_SCORE) 
                 FROM STUDENT AS S2 
                 WHERE S1.CLASS_ID=S2.CLASS_ID
                  GROUP BY S2.CLASS_ID
                   )
ORDER BY S1.CLASS_ID