题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
select min(score) from (select score ,avg(score) over(partition by tag) as avg_s from exam_record left join examination_info on exam_record.exam_id=examination_info.exam_id where tag='SQL' and score is not null) as A where score>=avg_s
用了一个窗口函数嘿嘿，突然心情非常好！
投递腾讯云智研发等公司7个岗位