---

-- 1
SELECT 
    LastName + N' ' + FirstName + N' ' + MiddleName AS FIO
FROM Client8
WHERE LastName LIKE N'И%';


-- 2
SELECT 
    AgreementNumber,
    PaymentDate,
    Amount,
    CurrencyCode
FROM PaymentDocument8
WHERE MONTH(PaymentDate) = MONTH(GETDATE())
  AND YEAR(PaymentDate) = YEAR(GETDATE());


-- 3
SELECT 
    v.Brand,
    v.Model,
    v.Color,
    c.NumberOfSeats,
    v.RentalPrice
FROM Vehicle8 v
JOIN Category8 c
    ON v.CategoryCode = c.CategoryCode
WHERE c.NumberOfSeats = 2
  AND v.Color = N'Красный';


-- 4
INSERT INTO Vehicle8
(VehicleCode, CategoryCode, RentalPrice, Brand, Model, Color, LicensePlate, CurrencyCode)
VALUES
(6,4,9000.00,N'Ford',N'Tourneo Custom',N'Белый',N'М333ММ77',1),
(7,4,9800.00,N'Hyundai',N'Starlink',N'Серый',N'Н444НН77',1),
(8,4,10500.00,N'Kia',N'Carnival',N'Черный',N'О555ОО77',1),
(9,4,11200.00,N'Toyota',N'Alphard',N'Серебристый',N'С666СС77',1),
(10,5,12500.00,N'BMW',N'2 Series Gran Tourer',N'Синий',N'Т777ТТ77',1),
(11,5,13800.00,N'Audi',N'Q7',N'Черный',N'У888УУ77',1),
(12,5,15000.00,N'Volvo',N'XC90',N'Белый',N'Х999ХХ77',1),
(13,5,16500.00,N'Land Rover',N'Discovery',N'Зеленый',N'А111АА78',1);

SELECT TOP 10
    v.Brand,
    v.Model,
    v.Color,
    c.NumberOfSeats,
    v.RentalPrice,
    v.LicensePlate
FROM Vehicle8 v
JOIN Category8 c
    ON v.CategoryCode = c.CategoryCode
WHERE c.NumberOfSeats = 7
ORDER BY v.RentalPrice DESC;


-- 5
SELECT 
    OfficeCode,
    City,
    Address
FROM RentalOffice8
WHERE City IN (N'Москва', N'Минск', N'Астана');


-- 6
SELECT 
    r.AgreementNumber
FROM RentalAgreement8 r
JOIN Client8 c
    ON r.ClientCode = c.ClientCode
WHERE c.LastName = N'Иванов'
  AND c.FirstName = N'Алексей'
  AND c.MiddleName = N'Сергеевич'
  AND c.City = N'Ярославль';