select exam_id, duration, release_time from ( select er.exam_id, ei.duration, release_time, timestampdiff(second,start_time,submit_time) as exam_time, row_number() over(partition by ei.exam_id order by timestampdiff(second,start_time,submit_time)) r1, row_number() over(partition by ei.exam_id order ...