题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
select min(score) min_score_over_avg from ( select score , avg(score)over(partition by tag) sql_avg from exam_record left join examination_info using (exam_id) where tag = 'SQL' ) a where score >= sql_avg
查看3道真题和解析