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

select tag,
    difficulty,
    round(avg(score),1) as clip_avg_score
from examination_info 
left join exam_record
on examination_info.exam_id = exam_record.exam_id
where tag = 'SQL' and difficulty = 'hard'and 
    score not in (
        (select max(score) from exam_record),
        (select min(score) from exam_record)
    )