---

SELECT DISTINCT
    c.id_car AS `ID автомобиля`,
    c.marka AS `Марка`,
    c.model AS `Модель`
FROM car c
WHERE EXISTS (
    SELECT 1
    FROM otziv o
    WHERE o.id_car = c.id_car
      AND o.ocenka = 10
)
AND NOT EXISTS (
    SELECT 1
    FROM dogovor d
    JOIN shtrafi s
        ON s.id_dogovor = d.id_dogovor
    WHERE d.id_car = c.id_car
);