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