题解 | 得分不小于平均分的最低分
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
select
min(score) min_score_over_avg
from
(
select
score,avg(score) over() avg_score_for_sql
from exam_record er
join examination_info ei using(exam_id)
where ei.tag='SQL' and er.score is not null
) a
where a.score >= avg_score_for_sql
