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

select min(er.score) as 
min_score_over_avg
from exam_record  er join examination_info  ei
on er.exam_id=ei.exam_id
where ei.tag='SQL' and score >=
(select avg(er.score)
from exam_record  er join examination_info  ei
on er.exam_id=ei.exam_id
where ei.tag='SQL' 
)

解释
在SQL卷子里面大于等于平均分的部分选最小