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