题解 | #第二快/慢用时之差大于试卷时长一半的试卷#

select exam_id,duration,release_time from
(
select distinct a.exam_id,duration,release_time,max(timestampdiff(minute,start_time,submit_time))over(partition by exam_id) max_time,
min(timestampdiff(minute,start_time,submit_time))over(partition by exam_id) min_time from 
examination_info a left join exam_record b
on a.exam_id = b.exam_id
where submit_time is not null
) d 
where max_time-min_time > duration/2 
order by exam_id desc;