Record-Breaking Days
Medium
Rolling Metrics
Return the days on which sales were strictly higher than on every earlier day (the first day counts). 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.