WITH

A AS

( SELECT ROW_NUMBER() OVER(ORDER BY TRIP_NO ASC) R

, ROW_NUMBER() OVER(ORDER BY TRIP_NO DESC) RR

, TRIP_NO T FROM TRIP )

, B AS

( SELECT R, RR, T T1

, LAST_VALUE(T) OVER(ORDER BY...