Accenture interview question

Rank function and window function use case amd sample queries