Car rental utilization by city (SQL)
Given tables of rental cars and their rentals, write SQL that reports utilization per city: how much of the available fleet time in each city was actually rented over a period. Agree on the definition of utilization first, then aggregate by city.
No answer yet. Write the first one; the best answer gets endorsed.
