Find Peak Rolling Sales Period

SQL coding challenge · Difficulty: medium · +200 XP

Marketing wants to know: which 7-day window had the highest total sales ever? Find the single date where the 7-day rolling sum was at its peak.

Return: date, rolling_7day_sum (just the peak row).