Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Days Above the Moving Average

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.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.