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

Quarter-wise Sales

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.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

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