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

select
    min(score) as min_score_over_avg
from
    (
        select
           score,
            avg(score) over (
                partition by
                    tag
            ) as avg_score
        from
            exam_record a
            join examination_info b on a.exam_id = b.exam_id
        where
            tag = 'SQL'
    ) a
where
    score >= avg_score