select exam_id, examination_info.duration, examination_info.release_time from (select exam_id,short_time from (select exam_id, timestampdiff(second,start_time,submit_time) as short_time, row_number() over(partition by exam_id order by timestampdiff(second,start_time,submit_time) asc) as ranking from...