Tekshirdi: O’qtuvchi Mamatova H. X

7.2 So’rovlar bilan ishlash

1. ijaraga olingan vaqt va tugash vaqtti bo’yicha shartnomalarni qidirish

SELECT Reservation.CustomerID, Reservation.CarID, Reservation.PickupDate

FROM Reservation
WHERE (((Reservation.PickupDate) Between [Pickup Date] And [Return Date]));

Natija

2. MatteBlack rangdagi Avtomobillar
SELECT c.BrandName, c.Model, c.ColorID
FROM Car AS c INNER JOIN Color AS co ON c.ColorID=co.ColorID
WHERE c.ColorID=8;

Natija
3. Mijozlarni Ism Familya Shahari bo’yicha qidirsh
SELECT Customers.FirstName, Customers.LastName, Customers.Addres
FROM Customers
WHERE (((Customers.FirstName) Like "*" & [Forms]![Search_Customer]![FirstName] & "*") AND ((Customers.LastName) Like "*" & [Forms]![Search_Customer]![LastName] & "*") AND ((Customers.Addres) Like "*" & [Forms]![Search_Customer]![City] & "*"));
Forma
Natija
4. Hodimlarni Ism familya Shahar bo’yicha qidirish
SELECT Worker.FirstName, Worker.Lastname, Worker.Addres, Worker.PositionID
FROM Worker
WHERE (((Worker.FirstName) Like "*" & [Forms]![Search_Worker]![FirstName] & "*") AND ((Worker.Lastname) Like "*" & [Forms]![Search_Worker]![LastName] & "*") AND ((Worker.Addres) Like "*" & [Forms]![Search_Worker]![City] & "*"));
Forma
Natija
5. Eng ko'p mijozlar bilan ishlagan hodimlar
SELECT TOP 5 w.WorkerID, w.firstname, w.Lastname, w.PositionID, r.CustomerID
FROM Worker AS w, reservation AS r
WHERE (((w.WorkerID)=[r].[WorkerID]))
GROUP BY w.WorkerID, w.firstname, w.Lastname, w.PositionID, r.CustomerID
ORDER BY Sum(r.WorkerID) DESC;

Natija
6. 2020-yil 12iyunda ijaraga berilgan Avtomobillar ro'yhati
SELECT c.CompanyID, c.BrandName, c.Model, c.ColorID, c.Year_of_issue
FROM car AS c INNER JOIN reservation AS r ON c.CarID=r.CarID
WHERE YEAR(r.PickupDate)=2020 and MONTH(r.PickupDate)=6 and DAY(r.PickupDate)=12;

Natija
7. Ijara narxi 500 000 dan 1 000 000 gacha bo'lgan avtomobillar

SELECT Car.BrandName, Car.Model
FROM Car
WHERE (((Car.[one_day_rental_price]) Between 500000 And 1000000));

Natija