select uid, exam_id, round(sum(avg_score)/count(exam_id),0) avg_new_score from( select uid, exam_id, if(max_score=min_score,score,(score-min_score)/(max_score-min_score)*100) avg_score from ( select uid, er.exam_id, ...