Monthly Revenue

Return the total order amount for each calendar month as 'YYYY-MM' with the column names month and revenue, 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-25 | 200
3 | 2026-02-03 | 150