MAX(DURATION) OVER (PARTITION BY ID ORDER BY DATE DESC),
       MAX(DURATION) OVER (PARTITION BY ID)