题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
select score min_score_over_avg from exam_record a, examination_info b where a.exam_id= b.exam_id and tag='SQL' and a.score>=(select avg(score) from exam_record c, examination_info d where c.exam_id= d.exam_id and tag='SQL' ) and a.score is not null order by a.score asc limit 1
查看4道真题和解析
可能从看你有勇气拒唯一的海康开始，我就被你折服了
这真的是最好的结局！