Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE CAR_SALES ( 
                        NUM_CARS       INT, 
                        EQUIPMENT_TYPE VARCHAR2(100), 
                        LOCATION       VARCHAR2(500), 
                        SOLD_DATE      DATE
                       );
   
begin
 insert into car_sales (num_cars,equipment_type,location,sold_date) values (8,'Rovers','coventry',timestamp'2019-09-07 10:00:12');
 insert into car_sales (num_cars,equipment_type,location,sold_date) values (1,'Rovers','coventry',timestamp'2019-09-07 10:00:45');
 insert into car_sales (num_cars,equipment_type,location,sold_date) values (9,'Jaguars','coventry',timestamp'2019-09-07 06:00:00');
 insert into car_sales (num_cars,equipment_type,location,sold_date) values (7,'Rovers','leamington',timestamp'2019-08-30 13:10:13');
end;
/
1 rows affected

SELECT location, TO_CHAR(sold_date,'yyyy-mm-dd hh24:mi') AS sold_date_to_minutes,
       LISTAGG(equipment_type,',') WITHIN GROUP 
       ( ORDER BY location, TO_DATE(sold_date,'yyyy-mm-dd hh24:mi') ) AS equipment_type
  FROM car_sales c
 GROUP BY location, TO_CHAR(sold_date,'yyyy-mm-dd hh24:mi')

                  


LOCATION
SOLD_DATE_TO_MINUTES
EQUIPMENT_TYPE


coventry
2019-09-07 06:00
Jaguars

coventry
2019-09-07 10:00
Rovers,Rovers

leamington
2019-08-30 13:10
Rovers

LOCATION	SOLD_DATE_TO_MINUTES	EQUIPMENT_TYPE
coventry	2019-09-07 06:00	Jaguars
coventry	2019-09-07 10:00	Rovers,Rovers
leamington	2019-08-30 13:10	Rovers