Rapyd interview question

Q: An SQL window function question + Data analysis question.