select tag ,difficulty ,round((总分-score-maxscore)/(总数-2),1)clip_avg_score from ( select t1.exam_id exam_id ,tag ,difficulty ,score ,row_number()over(partition by t1.exam_id,t2.tag,t2.difficulty order by t1.score) r ,first_value(score)over(partition by t1.exam_id,t2.tag,t2.difficulty order by score d...
