Visa Inc. Interview Question

SQL question on SELECT statement