You are given a backlog snapshot table and asked to identify the top drivers of backlog growth over time. Write a PostgreSQL query that measures month-over-month backlog change for each queue, ranks queues within each month by their contribution to growth, and returns the ranked results in chronological order.
You are given a backlog snapshot table and asked to identify the top drivers of backlog growth over time. Write a PostgreSQL query that measures month-over-month backlog change for each queue, ranks queues within each month by their contribution to growth, and returns the ranked results in chronological order.
