Pregunta de entrevista de ironSource

SQL joins between several tables with basic filtering and rank