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

# 写思路：截断总分：sum(score)-max(score)-min(score)

# 截断个数 count(score)-2

# 如果个数少于3

# if(count(score)<3,0,(sum(score)-max(score)-min(score))/(count(score)-2))

select tag,difficulty,round(if(count(score)<3,0,(sum(score)-max(score)-min(score))/(count(score)-2)),1) clip_avg_score

from examination_info ei join exam_record using(exam_id)

where tag='SQL' and difficulty='hard'