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.