题解 | 得分不小于平均分的最低分
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
with sql_avg as (
select
er.score score,
avg(if(er.score is not null, er.score, null)) over(partition by ei.tag) avg_score
from exam_record er left join examination_info ei
on er.exam_id = ei.exam_id
where ei.tag = 'SQL'
)
select min(score) min_score_over_avg
from sql_avg
where score>=avg_score
查看11道真题和解析