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