--CARS table
car_id (PK), car_model, car_miles

--TRIPS table
trip_id (PK), trip_destination, trip_date, trip_miles, car_id (FK)

--CARS table
C01, FORD Edge, 100,000
C02, CHEVY Malibu, 89,200
C03, DODGE Avenger, 75,000

--TRIPS table
T01, NYC, 10-jul-2019, 20, C01
T02, Brooklyn, 12-jul-2019, 15, C01
T03, NYC,  09-jul-2019,25, C03

Car_MODEL     | TOTAL TRIPS
--------------|------------
FORD EDGE     | 2
DODGE AVENGER | 1

--SQL Query
SELECT SUM(trip_id), car.car_model
FROM trips
LEFT LEFT JOIN car ON trips.car_id = car.car_id
WHERE trips.car_id = car.car_id;