Pergunta de entrevista da empresa Lyft

SQL question - walk through thought process, and write out query