select distinct rk.exam_id,duration,release_time from ( select exam_id, nth_value(timestampdiff(second,start_time,submit_time),2)over(partition by exam_id order by timestampdiff(second,start_time,submit_time))&nb...