思路:在表的右边加一列,填入平均值,再对新表过滤出大于平均值和SQL的行,取得分最小值就行了
select min(y.score) as min_score_over_avg from exam_record as y left join examination_info as ei using(exam_id) join ( select avg(score) as aa from examination_info join exam_record using(exam_id) where tag='SQL') as z where y.score>=z.aa and ei.tag='SQL'