Quarter-wise Sales
Medium
Date Arithmetic
Return the total amount per quarter of the year as 'Q1'..'Q4' for quarters that have sales, ordered by quarter.
Table schema
Orders(id INT PRIMARY KEY, order_date DATE, amount INT)Sample data
id | order_date | amount
1 | 2026-01-15 | 100
2 | 2026-02-10 | 50
3 | 2026-04-01 | 70
4 | 2026-11-30 | 30
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.