Mastercard interview question

Write SQL queries based on your DB design