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