---

SELECT R.id_rejs, A.marka, A.gosnomer, R.mesto_naznacheniya, R.data_vyezda
FROM Rejsy R
JOIN Avtomobili A ON R.id_avto = A.id_avto;

SELECT V.fio, A.marka, SUM(R.rashod_goryuchego) AS total_rashod
FROM Rejsy R
JOIN Voditeli V ON R.id_voditel = V.id_voditel
JOIN Avtomobili A ON R.id_avto = A.id_avto
GROUP BY V.fio, A.marka;

SELECT * FROM Avtomobili WHERE id_avto = 2;

UPDATE Avtomobili SET tech_sostoyanie = 'на ремонте' WHERE id_avto = 2;

SELECT * FROM Avtomobili WHERE id_avto = 2;

SELECT * FROM Rejsy WHERE id_rejs = 3;


DELETE FROM Rejsy WHERE id_rejs = 3;

SELECT * FROM Rejsy WHERE id_rejs = 3;