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

select
    min(score) min_score_over_avg
from
    exam_record a
    join examination_info b on a.exam_id = b.exam_id
where
    tag = 'SQL'
    and score is not null
    and score >= (
        select
            avg(score)
        from
            exam_record r
             join examination_info i on r.exam_id = i.exam_id
        where
            tag = 'SQL'
            and score is not null
    )