ironSource interview question

SQL joins between several tables with basic filtering and rank