题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
select min(score) from examination_info t2 join (select * from(SELECT exam_id,uid,score, avg(score) over(partition by exam_id) avg_score from exam_record where score>0 ) t where t.score>=t.avg_score ) t1 on t1.exam_id=t2.exam_id where tag="SQL"
