Welcome to your interview.
The question is on your right: Window Ranking in Ticket Queues. Take a moment with it first.
Talk your thinking through with me if you like - when you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes). Discussion and graded submissions share your five interviewer interactions, so spend them well.
Window functions are common in reporting and operational analytics because they let you calculate values across related rows without collapsing the result set. In PostgreSQL, they are especially useful for ranking, sequencing, and comparing records within groups.
You are asked to explain what window functions are in SQL and how they differ from regular aggregate functions. Then explain when you would use ROW_NUMBER() versus DENSE_RANK() in a ranking scenario, such as ordering Infosys BPM support tickets or analyst work items within a queue.
Your answer should define the OVER() clause, describe how partitioning and ordering affect results, and compare the behavior of ROW_NUMBER() and DENSE_RANK() when ties exist. The interviewer expects both a conceptual explanation and a small PostgreSQL example that shows why the two functions return different outputs.