Advanced
Generate SQL Query for Analysis
Write a SQL query to answer a specific business question.
📝 Prompt Content
Write a SQL query for a table named 'sales' with columns 'id', 'product_name', 'quantity', 'price', and 'sale_date'. The query should return the total revenue generated by each product in the month of October 2023.