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

#select min(exam_record.score) as min_score_overOavg from exam_record 
#join examination_info 
#on exam_record.exam_id=examination_info.exam_id 
#where examination_info.tag='SQL' 
# and exam_id.score>=avg(select avg(exam_record.score) from exam_record 
# join examination_info on exam_record.exam_id=examination_info.exam_id where #tag='SQL')
select min(exam_record.score) as min_score_over_avg from exam_record join examination_info on exam_record.exam_id=examination_info.exam_id where examination_info.tag='SQL' and exam_record.score >= (select avg(exam_record.score) from exam_record join examination_info where exam_record.exam_id=examination_info.exam_id and examination_info.tag='SQL')