SELECT ID,
       MAX(DURATION) OVER (PARTITION BY ID ORDER BY DATE DESC),
       MAX(DURATION) OVER (PARTITION BY ID)
FROM T1;