Pergunta de entrevista da empresa Mastercard

They asked me 2 case studies, followed by a few SQL questions (especially sub-queries)