---

SELECT
    c.id_car AS 'ID автомобиля',
    c.marka AS 'Марка',
    c.model AS 'Модель',
    COUNT(o.id_otziv) AS 'Количество отзывов'
FROM car c
LEFT JOIN otziv o ON c.id_car = o.id_car
GROUP BY
    c.id_car,
    c.marka,
    c.model
ORDER BY COUNT(o.id_otziv) DESC;