Uber interview question

Sql queries around window functions