Question d’entretien chez Uber

Write a sql query about two tables (inner join, select from, where clause, case when)