题解 | #得分不小于平均分的最低分#

SELECT MIN(score) AS min_score_over_avg
FROM exam_record
JOIN examination_info
    USING(exam_id)
WHERE tag = "SQL" AND score >= (
    SELECT AVG(score)
    FROM exam_record
    JOIN examination_info USING(exam_id)
    WHERE tag = "SQL"
)

• 求助一下大家，有没有更简便的方法：不使用子查询就能实现的方法