---

SELECT
    c.id_car,
    c.marka,
    c.model,
    c.data_vipuska,
    t.nazvanie AS toplivo,
    k.nazvanie AS korobka,
    MAX(obs.probeg) AS maksimalnyy_probeg
FROM car c
LEFT JOIN toplivo t ON c.id_toplivo = t.id_toplivo
LEFT JOIN korobka k ON c.id_korobka = k.id_korobka
LEFT JOIN teh_obs obs ON c.id_car = obs.id_car
GROUP BY
    c.id_car,
    c.marka,
    c.model,
    c.data_vipuska,
    t.nazvanie,
    k.nazvanie;