题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
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卷子里面大于等于平均分的部分选最小
