Mastercard interview question

Multi-tier SQL queries with all the joins