Uber Interview Question

Some SQL questions around joins and ranking