Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table table_name ( RESERVATION, PREFIX, FLIGHT, ORIGIN, DESTINATION, DATE_FLIGHT ) AS
SELECT 111, 'LA', 123, 'LAX', 'MIA', DATE '2020-02-01' + INTERVAL '00:00' HOUR TO MINUTE FROM DUAL UNION ALL
SELECT 111, 'LA', 122, 'MIA', 'SCL', DATE '2020-02-01' + INTERVAL '10:30' HOUR TO MINUTE FROM DUAL UNION ALL
SELECT 111, 'LA', 667, 'MIA', 'SCL', DATE '2020-02-03' + INTERVAL '14:15' HOUR TO MINUTE FROM DUAL UNION ALL
SELECT 111, 'LA', 882, 'SCL', 'ARG', DATE '2020-02-03' + INTERVAL '16:00' HOUR TO MINUTE FROM DUAL UNION ALL
SELECT 111, 'LA', 111, 'SCL', 'ARG', DATE '2020-02-03' + INTERVAL '23:00' HOUR TO MINUTE FROM DUAL UNION ALL
SELECT 111, 'LA', 966, 'SCL', 'ARG', DATE '2020-02-03' + INTERVAL '23:30' HOUR TO MINUTE FROM DUAL UNION ALL
SELECT 111, 'LA', 622, 'SCL', 'ARG', DATE '2020-02-05' + INTERVAL '08:00' HOUR TO MINUTE FROM DUAL;
7 rows affected

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
SELECT reservation,
       MIN( prefix      ) KEEP ( DENSE_RANK FIRST ORDER BY date_flight ) AS prefix_min,
       MIN( flight      ) KEEP ( DENSE_RANK FIRST ORDER BY date_flight ) AS flight_min,
       MIN( origin      ) KEEP ( DENSE_RANK FIRST ORDER BY date_flight ) AS origin_min,
       MIN( destination ) KEEP ( DENSE_RANK FIRST ORDER BY date_flight ) AS desination_min,
       MIN( date_flight ) AS date_flight_min,
       MIN( prefix      ) KEEP ( DENSE_RANK LAST ORDER BY date_flight ) AS prefix_max,
       MIN( flight      ) KEEP ( DENSE_RANK LAST ORDER BY date_flight ) AS flight_max,
       MIN( origin      ) KEEP ( DENSE_RANK LAST ORDER BY date_flight ) AS origin_max,
       MIN( destination ) KEEP ( DENSE_RANK LAST ORDER BY date_flight ) AS desination_max,
       MAX( date_flight ) AS date_flight_max
FROM   table_name
GROUP BY reservation;


RESERVATION
PREFIX_MIN
FLIGHT_MIN
ORIGIN_MIN
DESINATION_MIN
DATE_FLIGHT_MIN
PREFIX_MAX
FLIGHT_MAX
ORIGIN_MAX
DESINATION_MAX
DATE_FLIGHT_MAX


111
LA
123
LAX
MIA
2020-02-01 00:00:00
LA
622
SCL
ARG
2020-02-05 08:00:00