---

SELECT
    c.marka AS 'Марка автомобиля',
    c.model AS 'Модель автомобиля',
    COUNT(d.id_dogovor) AS 'Количество аренд'
FROM car c
JOIN dogovor d ON c.id_car = d.id_car
GROUP BY
    c.id_car,
    c.marka,
    c.model
HAVING COUNT(d.id_dogovor) > 5
ORDER BY COUNT(d.id_dogovor) DESC;