题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
select
round(min(score))
from
exam_record a
left join examination_info b on a.exam_id = b.exam_id
where
b.tag = 'SQL'
and
a.score>=
(select
round(avg(score))
from
exam_record a
left join examination_info b on a.exam_id = b.exam_id
where
tag = 'SQL')
