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

本题的难点在于需要先通过子查询找出平均值并且向上取整(ceil(avg)),之后在通过score进行一个数据判断

select
    min(score) as min_score_over_avg
from
    exam_record
    join examination_info using (exam_id)
where
    tag = "SQL"
    AND score >= (
        select
            ceiling(avg(score)) as avgnum
        from
            exam_record
            join examination_info using (exam_id)
        where
            tag = "SQL"
    )