Days Where Rolling Sum Increased by 20% vs Previous Day

SQL coding challenge · Difficulty: hard · +250 XP

Your risk team wants to detect unusual growth spikes. Find every day where the 7-day rolling sales total jumped by 20% or more compared to the previous day's 7-day rolling total.

Return: date, rolling_sum, prev_rolling_sum, pct_change

Sort by date ascending.