题解 | #SQL类别高难度试卷得分的截断平均值#

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