medium
SQL Revenue Report Query
Write a SQL query to generate a monthly revenue report.
📝 Contenu du Prompt
Write a SQL query for a table named 'orders' that calculates total revenue per month for the year 2023. The table has columns: order_id, amount, and order_date. Group the results by month and order them chronologically. Include the SQL query and a brief explanation of how the date functions work.