
Write a PostgreSQL query that explains a month-over-month revenue decline by breaking the change across multiple dimensions in Zulily reporting data. The result should compare each dimension value to its prior month, keep only negative movers, and show which values contributed most to the overall decline.
Month being analyzedDimension type and dimension valueCurrent and prior-month revenueAbsolute and percent revenue changeContribution to total monthly declineRank of the biggest negative drivers