题解 | #得分不小于平均分的最低分#不小于就用大于或等于
得分不小于平均分的最低分
http://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
select min(score) as min_score_over_avg
from exam_record t1
join examination_info t2
on t1.exam_id = t2.exam_id and t2.tag = 'SQL' and t1.score is not null
where t1.score >= (
select avg(score)
from exam_record t1
join examination_info t2
on t1.exam_id = t2.exam_id and t2.tag = 'SQL' and t1.score is not null
)
