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

select tag,difficulty,round((sum(b.score)-max(b.score)-min(b.score))/(count(b.score)-2),1) as clip_avg_score from examination_info a,exam_record b where a.exam_id=b.exam_id 
and a.tag='SQL' and a.difficulty='hard'