题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
select min(score) as min_score_over_avg
from exam_record as er
left join examination_info as ei
on er.exam_id=ei.exam_id
where ei.tag="SQL"
and score>=(select avg(score) from exam_record as er join
examination_info as ei on er.exam_id=ei.exam_id
where tag="SQL")
投递荣耀等公司10个岗位