题解 | #SQL类别高难度试卷得分的截断平均值#
SQL类别高难度试卷得分的截断平均值
https://www.nowcoder.com/practice/a690f76a718242fd80757115d305be45
#①（总-最大值-最小值）/count(score)-2 select tag,difficulty,round((sum(score)-max(score)-min(score))/(count(score)-2),1) clip_avg_score from exam_record a left join examination_info b on a.exam_id=b.exam_id where tag='SQL' and difficulty='hard'
查看15道真题和解析
