题解 | #SQL类别高难度试卷得分的截断平均值#
SQL类别高难度试卷得分的截断平均值
https://www.nowcoder.com/practice/a690f76a718242fd80757115d305be45
select tag, difficulty , round((sum(score) - min(score) - max(score)) / (count(score) - 2), 1) clip_avg_score from exam_record left join examination_info using (exam_id) where tag = 'SQL' and difficulty = 'hard' and submit_time is not null group by tag, difficulty
