WITH t as( SELECT exam_id, TIMESTAMPDIFF(SECOND,start_time,submit_time) AS use_time, ROW_NUMBER()OVER(PARTITION BY exam_id ORDER BY TIMESTAMPDIFF(MINUTE,start_time,submit_time) ASC) AS fast_rank, ROW_NUMBER()OVER(PARTITION BY exam_id ORDER BY TIMESTAMPDIFF(MINUTE,start_time,submit_time) DESC) AS slo...
