Identify 4-Day Consecutive Rolling Sum Increase

SQL coding challenge · Difficulty: hard · +250 XP

Your analyst is investigating a sales surge event. They want to know the first date when the 4-day rolling total increased for 4 consecutive days in a row — a signal that a promotion or viral event caused sustained growth.

Return: the single date (and its rolling sum) where the 4th consecutive increase occurred.