#思路: #①选出SQL的exam_id; #②将前一步选出的exam_id作为子查询,选出这些exam_id对应的score和平均分; #③选出score>=平均分情况下的min(score)即可。 select min(score) from (select score, avg(score)over() a from exam_record where exam_id in (select exam_id from examination_info where tag='SQL') ) as tb1 where score>=a