Hi Experts
I have the following sample query below
with t_info(id, st_date, end_date, place_info) as
(
select 1, to_date('01/01/2012', 'MM/DD/YYYY'), to_date('01/31/2012', 'MM/DD/YYYY'), 'New York' from dual
union all
select 1, to_date('02/01/2013', 'MM/DD/YYYY') , to_date('07/24/2014', 'MM/DD/YYYY'), 'Boston' from dual
union all
select 1, to_date('12/31/2024', 'MM/DD/YYYY'), to_date('01/01/2025', 'MM/DD/YYYY'), 'London' from dual
)
select * from t_info;
I would like help with the following result below if possible. thanks in advance
id earliest_place_info latest_place_info
1 New York London