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

select
    score as min_score_over_avg
from
    exam_record as tp1
    inner join examination_info as tp2 on tp1.exam_id = tp2.exam_id
where
    tp2.tag = 'SQL'
    and score >= (
        select
            avg(t1.score) as avg_score
        from
            exam_record as t1
            inner join examination_info as t2 on t1.exam_id = t2.exam_id
        where
            t2.tag = 'SQL'
        group by
            t2.tag
    )
order by
    score asc
limit
    1;