MoM Growth in Support Channels

Wayfair wants to compare how effectively customers are resolved through self-service experiences and live agent support. Write a PostgreSQL query that reports monthly resolved interactions for both channels and their month-over-month growth.

Requirements

1. Join interaction logs to active Wayfair customers only.
2. Count interactions where resolved = TRUE separately for self_service and live_agent.
3. Calculate month-over-month percentage growth for each channel using LAG.
4. Return one row per month from January through April 2024, ordered chronologically. Return NULL growth when no prior month exists or the prior count is zero.

Output details

• Return columns in this order: month, self_service_resolutions, self_service_mom_growth_pct, live_agent_resolutions, live_agent_mom_growth_pct.
• Format month as YYYY-MM.
• Round both percentage-growth columns to 2 decimal places.
• Include timestamps from 2024-01-01 00:00:00 inclusively through 2024-05-01 00:00:00 exclusively.