问在SQL中显示最大第三值对应的日期和id

EN

select d.driver_id, d.name, t.travel_date 
from(
    select dB.driver_id,
    max(timestampdiff(minute,start_time,arrival_time)) maxTime
    from droveBy dB
    join travel t on dB.travel_id = t.travel_id
         group by dB.driver_id)t1
 join travel t on t1.maxTime = timestampdiff(minute,t.start_time,t.arrival_time)
 join droveBy dB on t1.driver_id = dB.driver_id and t.travel_id = dB.travel_id
join Driver d on dB.driver_id = d.driver_id;