Pregunta de entrevista de Visa Inc.

SQL question based on joins and sub-query