必须注意聚合分数时直接avg会提示出错

select tag, difficulty, round((sum(score) - max(score) - min(score)) / (count(score) - 2), 1) as clip_avg_score from exam_record join examination_info using(exam_id) where tag="SQL" and difficulty="hard"