题解 | #SQL类别高难度试卷得分的截断平均值#
SQL类别高难度试卷得分的截断平均值
https://www.nowcoder.com/practice/a690f76a718242fd80757115d305be45
select
tag,
difficulty,
round(((sum(score) - max(score) - min(score)) / (count(if(score is not null, er.id, null)) - 2)), 1) as clip_avg_score
from
exam_record er
left join
examination_info ei on er.exam_id = ei.exam_id
where
tag = 'SQL'
and difficulty = 'hard'
投递七牛云等公司10个岗位
腾讯云智研发成长空间 5048人发布