Visa Inc. Interview Question

SQL question based on joins and sub-query