Skip to content

Instantly share code, notes, and snippets.


Michael Bensoussan mickey

View GitHub Profile

Instructions: solve the levels in ascending order, and send your code and data at 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: