You are analyzing customer transaction data in BigQuery to identify sales trends over time. You want to understand the average transaction amount per month to inform future marketing strategies. Which SQL query in BigQuery would best accomplish this goal?