Visa Inc. interview question

Sql questions for windows functions