---

USE avtoparkkk;

-- Простой запрос 1
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;

-- Простой запрос 2
SELECT R.id_rejs, V.fio, V.kategoriya, R.mesto_naznacheniya, R.massa_gruza
FROM Rejsy R
JOIN Voditeli V ON R.id_voditel = V.id_voditel;

-- Сложный запрос 1
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;

-- Сложный запрос 2
SELECT V.fio, A.marka, MIN(R.rashod_goryuchego) AS min_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;

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

-- DELETE
DELETE FROM Rejsy WHERE id_rejs = 3;