题解 | #得分不小于平均分的最低分#
得分不小于平均分的最低分
https://www.nowcoder.com/practice/3de23f1204694e74b7deef08922805b2
select min(score) min_score_over_avg
from (select*from exam_record where score is not null) p join examination_info f using(exam_id)
where tag='SQL' and score>=(
select
avg(score)
from (select*from exam_record where score is not null) n join examination_info t using(exam_id)
where tag='SQL'
from (select*from exam_record where score is not null) p join examination_info f using(exam_id)
where tag='SQL' and score>=(
select
avg(score)
from (select*from exam_record where score is not null) n join examination_info t using(exam_id)
where tag='SQL'
);
这里关联查表的时候，必须要过滤掉表中score is null的数据，否则null计算不了
查看20道真题和解析