KOHO interview question

You have 3 hours to: 1 - Solve a simple algorithm 2 - Solve a fairly complex SQL Select, but if you have solid SQL knowledge you shouldn't have any problems with it. 3 - You have to finish coding an API that queries data from AWS