保留1位小数:round(..., 1)
select tag, difficulty,
round((sum(score) - max(score) - min(score)) / ((count(score) - 2)), 1) as clip_avg_score
from exam_record as er left join examination_info as ei
on er.exam_id = ei.exam_id
where difficulty = 'hard' and tag = 'SQL';