---

SELECT
    car.id_car,
    car.marka,
    car.model,
    COUNT(DISTINCT dogovor.id_dogovor) AS `Количество договоров`,
    COUNT(DISTINCT otziv.id_otziv) AS `Количество отзывов`
FROM car
LEFT JOIN dogovor
    ON car.id_car = dogovor.id_car
LEFT JOIN otziv
    ON car.id_car = otziv.id_car
GROUP BY
    car.id_car,
    car.marka,
    car.model
ORDER BY car.id_car;