Sales per Quarter

Return the total sales per calendar quarter (Q1-Q4) of 2026, only for quarters that have sales. Order by quarter.

Table schema

Sales(id INT PRIMARY KEY, sale_date DATE, amount INT)

Sample data

id | sale_date | amount
1 | 2026-01-05 | 100
2 | 2026-01-20 | 50
3 | 2026-02-14 | 70
4 | 2026-04-01 | 40
5 | 2026-05-10 | 90
6 | 2026-07-04 | 60
7 | 2026-07-05 | 30