Accenture Interview Question

Rank function and window function use case amd sample queries