题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
select min(t.score) as min_score_over_avg from( select ed.exam_id,score, avg(score)over(partition by exam_id) as pg from exam_record ed left join examination_info ef on ed.exam_id=ef.exam_id where ef.tag="SQL" ) as t where t.score>=t.pg
投递华为等公司10个岗位