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

Average Order Value per Month

Return month ('YYYY-MM'), number of orders and average order amount rounded to two decimals, ordered by month.

Table schema

Orders(id INT PRIMARY KEY, order_date DATE, amount INT)

Sample data

id | order_date | amount
1 | 2026-01-10 | 100
2 | 2026-01-20 | 200
3 | 2026-02-05 | 50

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.