Uber interview question

Some SQL questions around joins and ranking

Uber Interview Question: Some SQL questions around joins and ranking | Glassdoor