题解 | #得分不小于平均分的最低分#

select min(score) min_score_over_avg
from(
	select score,avg(score) over() 平均分
	from exam_record er inner join examination_info ei 
		on er.exam_id = ei.exam_id 
		and tag = 'SQL'
		and score is not null
	order by score 
	) as sub
where score >= 平均分;

# select min(score) min_score_over_avg
# from exam_record er inner join examination_info ei 
# 	on er.exam_id = ei.exam_id 
# 	and tag = 'SQL'
# 	and score is not null
# where score >= (
# 	select avg(score) 
# 	from exam_record er inner join examination_info ei 
# 		on er.exam_id = ei.exam_id 
# 		and tag = 'SQL'
# 		and score is not null
# 	);