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