Rapyd Interview Question

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