Uber Interview Question

Sql queries around window functions