122

WITH firstFlight
AS
(
--это не первые учитывай таймаут
SELECT DISTINCT ID_psg, MIN(date) OVER (PARTITION BY ID_psg) AS date
FROM Trip t
JOIN Pass_in_trip pit ON t.trip_no = pit.trip_no
),
lastFlight
AS
(
--это не последние учитывай таймин
SELECT DISTINCT ID_psg, MAX(date) OVER (PARTITION BY ID_psg) AS date
FROM Trip t
JOIN Pass_in_trip pit ON t.trip_no = pit.trip_no
)
SELECT *
FROM Trip t
JOIN Pass_in_trip pit ON t.trip_no = pit.trip_no
JOIN firstFlight ff ON pit.ID_psg = ff.ID_psg AND pit.date = ff.date