Instructions: solve the levels in ascending order, and send your code and data at [email protected] when you’re done. We love SQL tricks, but we also value your ease to write code. You can use any langage you like as long as you have a strategy to deploy and maintain this code.
Goal: Provide the BI team a report of the occupancy rate of the fleet per city.
For a certain half-day, we define the occupancy rate as the nb of rented cars / nb of available cars.
For a half day T, a car is considered available by default. This default state can be changed to: