ironSource Interview Question

SQL joins between several tables with basic filtering and rank