题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
select
min(score) as min_score_over_avg
from
exam_record
left join examination_info using (exam_id)
where
tag='SQL' and
score >= (
select
avg(score)
from
exam_record t1
left join examination_info t2 using (exam_id)
where
tag='SQL'
)
投递阿里云等公司10个岗位