Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table_name ( serial, make, model, upgrade_date, software_version ) AS
SELECT 'A', 'Terra', 1, DATE '2019-01-01', '1.1' FROM DUAL UNION ALL
SELECT 'A', 'Terra', 1, DATE '2019-06-17', '1.9' FROM DUAL UNION ALL
SELECT 'A', 'Terra', 1, DATE '2019-12-31', '2.1' FROM DUAL;
3 rows affected

select serial,
       make,
       model,
       LISTAGG( software_version, ',' ) WITHIN GROUP ( ORDER BY upgrade_date )
         AS Version_history,
       LISTAGG( upgrade_date, ',' ) WITHIN GROUP ( ORDER BY upgrade_date )
         AS Version_dates
FROM   table_name
GROUP BY serial, make, model
Order by serial


SERIAL
MAKE
MODEL
VERSION_HISTORY
VERSION_DATES


A
Terra
1
1.1,1.9,2.1
01-JAN-19,17-JUN-19,31-DEC-19


SELECT serial,
       make,
       model,
       "1.1",
       "1.9",
       "2.1",
       "2.3"
FROM   table_name
PIVOT ( MAX( upgrade_date ) FOR software_version IN (
  '1.1' AS "1.1",
  '1.9' AS "1.9",
  '2.1' AS "2.1",
  '2.3' AS "2.3"
) )


SERIAL
MAKE
MODEL
1.1
1.9
2.1
2.3


A
Terra
1
01-JAN-19
17-JUN-19
31-DEC-19
null