题解 | #统计作答次数#

SELECT MIN( er.score ) min_score_over_avg FROM exam_record er JOIN examination_info ei ON er.exam_id = ei.exam_id WHERE ei.tag='SQL' AND er.score>=(SELECT ROUND(AVG(er.score),1) avg_score FROM exam_record er JOIN examination_info ei ON er.exam_id = ei.exam_id WHERE ei.tag='SQL') ;