Septembrie 2023 ✅

Companies [CompanyID, Name, CountryOfOrigin]

Bicycles [BicycleID, CompanyID, Model, Size, DailyRentalPrice]

• {CompanyID} foreign key referencing {CompanyID} in Companies

Customers [CustomerCNP, Name, Phone, Email]

RentalForms [CustomerCNP, DateCreated]

• {CustomerCNP} foreign key referencing {CustomerCNP} in Customers

RentedBicycle [CustomerCNP, DateCreated, BicycleID, StartDate, EndDate]

• {CustomerCNP, DateCreated} foreign key referencing {CustomerCNP, DateCreated} in RentalForms

a.

SELECT DISTINCT D.DriverID, D.DriverName, D.Salary

FROM Drivers D

JOIN CARS C ON D.DriverID = C.DriverID

JOIN RIDES R ON C.CarID = R.CarID

WHERE C.CarMake = 'Ford' AND R.Destination = 'Iulius Mall Cluj'

ORDER BY D.Salary DESC