# 创建临时表,表中包含所需列外,再分别添加考试时长tdiff,考试时长升序r1和考试时长倒序r2 with temp as( select exam_id, duration, release_time, timestampdiff(minute, start_time, submit_time) tdiff, row_number() over(partition by exam_id order by timestampdiff(minute, start_time, submit_time)) r1, row_number() over...