Skip to content

Instantly share code, notes, and snippets.

Avatar

Michael Bensoussan mickey

View GitHub Profile
View instruction.md

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 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: