Days Above the Moving Average
Hard
Rolling Metrics
Return the days when sales exceeded the average of the previous two days (only days with two predecessors). Order by day.
Table schema
Daily(day DATE PRIMARY KEY, sales INT)Sample data
day | sales
2026-01-01 | 10
2026-01-02 | 30
2026-01-03 | 20
2026-01-04 | 50
2026-01-05 | 40
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.