Pergunta de entrevista da empresa ironSource

SQL joins between several tables with basic filtering and rank