MySQL 8.0

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

CREATE TABLE Cars (
    Car_ID INT,
    Car_Name VARCHAR(50),
    Owner VARCHAR(50)
);


INSERT INTO Cars (Car_ID, Car_Name, Owner) VALUES (1, 'Ferrari', 'Marco');
INSERT INTO Cars (Car_ID, Car_Name, Owner) VALUES (2, 'Jeep', 'Enrico');
INSERT INTO Cars (Car_ID, Car_Name, Owner) VALUES (3, 'Mercedes', 'Matteo');
INSERT INTO Cars (Car_ID, Car_Name, Owner) VALUES (1, 'Ferrari', 'Andrea');
INSERT INTO Cars (Car_ID, Car_Name, Owner) VALUES (3, 'Mercedes', 'Giorgio');
INSERT INTO Cars (Car_ID, Car_Name, Owner) VALUES (2, 'Jeep', 'Gianluca');
select Car_ID,Car_Name,group_concat(Owner) as Owners from Cars
group by Car_ID,Car_Name


Car_ID
Car_Name
Owners


1
Ferrari
Marco,Andrea

2
Jeep
Enrico,Gianluca

3
Mercedes
Matteo,Giorgio

Car_ID	Car_Name	Owners
1	Ferrari	Marco,Andrea
2	Jeep	Enrico,Gianluca
3	Mercedes	Matteo,Giorgio