题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
with cte as( select score,score-avg(score)over() as a_score from exam_record join examination_info using(exam_id) where tag='SQL' and score is not null order by a_score ) select score as min_score_over_avg from cte where a_score>=0 limit 1
投递汇川技术等公司10个岗位