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