For every rental, calculate the rental amount as the number of days between StartDate and EndDate multiplied by the DailyRate. Display CarRegistration, Owner, DailyRate, StartDate, EndDate and the calculated field as RentAmount.
Database
RentMyParking
A company renting out parking bays to car owners. Adapted from a real IEB exam — premium bays are covered and secured, and a car can be parked at any bay on any given day.
Loading in-browser database…
Run your query to see results here.