题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
with temp as(
#得到SQL试卷的平均分
select
avg(score) as score_avg
from exam_record a, examination_info b
where tag = 'SQL'
and a.exam_id = b.exam_id)
#找到得分不小于平均分的最低分
select
min(score) as min_score_over_avg
from exam_record a, examination_info b,temp
where b.tag = 'SQL'
and a.exam_id = b.exam_id
and score >= score_avg
