題解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
http://www.fangfengwang8.cn/practice/3de23f1204694e74b7deef08922805b2
select
min(score) min_score_over_avg
from
exam_record a
join examination_info b on a.exam_id = b.exam_id
where
tag = 'SQL'
and score is not null
and score >= (
select
avg(score)
from
exam_record r
join examination_info i on r.exam_id = i.exam_id
where
tag = 'SQL'
and score is not null
)
順豐集團(tuán)工作強(qiáng)度 111人發(fā)布
