medium
Monthly Sales Report Query
Generate a SQL query for aggregating sales data.
📝 Nội dung Prompt
Write a SQL query for a table named 'orders' with columns 'order_id', 'customer_id', 'amount', and 'order_date'. The query should return the total sales amount and the number of orders for each month in the year 2023, ordered by month.