Visa Inc. interview question

SQL question on SELECT statement