select exam_id,duration,release_time from (select a.exam_id,duration,release_time,use_time, row_number() over(partition by exam_id order by use_time desc) as r1, row_number() over(partition by exam_id order by use_time ) as r2 from examination_info a left join (select *,timestampdi...