Average Order Value per Month
Medium
Aggregation & GROUP BY
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.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.