Weekly Totals
Medium
Time Series SQL
Group sales by week where a week starts on Monday and return the week's start date and the total amount. Order by week start.
Table schema
Sales(sale_date DATE, amount INT)Sample data
sale_date | amount
2026-10-05 | 10
2026-10-07 | 20
2026-10-12 | 5
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.