题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
# 找到SQL试卷得分不小于该类试卷平均得分的用户最低得分。 SELECT score FROM exam_record JOIN examination_info USING(exam_id) WHERE tag='SQL' AND score >= (SELECT AVG(score) as score_avg FROM exam_record JOIN examination_info USING(exam_id) WHERE tag='SQL') ORDER BY score ASC LIMIT 1