题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
http://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
SELECT min(score) min_score_over_avg from exam_record er join examination_info ei on er.exam_id=ei.exam_id where tag="SQL" and score>=(SELECT avg(score) from exam_record where exam_id in (9001,9002))