Instructions: Solve the levels in ascending order, and send your code and data at guillemette@drivy.com when you’re done. We love SQL tricks, but we also value your ease to write code. You can use any langage you like (brainfuck anyone?) 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 or rented cars.
For a half day T, a car is considered available by default. This default state can be changed to: