题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
http://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
with t as (select er.score from exam_record er join examination_info ei on er.exam_id = ei.exam_id where ei.tag = 'SQL' and er.score is not null ) select t.score as min_score_over_avg from t where t.score >= (select avg(m.score) from (select er.score from exam_record er join examination_info ei on er.exam_id = ei.exam_id where ei.tag = 'SQL' and er.score is not null ) m) order by t.score asc limit 1 ;