非相关子查询.sql

初学者

SELECT STU_NAME AS '学生名',STU_SCORE AS '成绩'
FROM STUDENT
WHERE STU_SCORE>(SELECT AVG(STU_SCORE) FROM STUDENT)
/*查询成绩大于平均成绩的学生*/