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

select
    min(score) as min_score_over_avg
from
    exam_record 
    left join examination_info using (exam_id)
where
    tag='SQL' and
    score >= (
        select
            avg(score)
        from
            exam_record t1
            left join examination_info t2 using (exam_id)
        where 
            tag='SQL'
    )