Mastercard Interview Question

Multi-tier SQL queries with all the joins