题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
with t as( select a.*,tag,avg(score) over(partition by a.exam_id) as avg_score from exam_record a left join examination_info b on a.exam_id = b.exam_id where score is not null ) select min(score) min_score_over_avg from t where score >= avg_score and tag='SQL'