Pergunta de entrevista da empresa Google

SQL query involving joins and analytical functions