Analyze Monthly Revenue Trends by Product Category

A financial analytics platform needs to analyze revenue trends by product category over the past year. Write a SQL query to calculate the monthly total revenue for each category, along with the cumulative revenue for each category ordered by month.

Requirements

Group revenue by category and transaction_month
Calculate total revenue per category per month
Include cumulative revenue for each category
Order results by category and transaction_month

Schema

transactions

Column	Type	Description
idPK	INT	Primary key
category	VARCHAR	Product category
transaction_date	DATE	Date of transaction
amount	DECIMAL	Transaction amount

Your question is Analyze Monthly Revenue Trends by Product Category. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Requirements

Group revenue by category and transaction_month
Calculate total revenue per category per month
Include cumulative revenue for each category
Order results by category and transaction_month

Schema

transactions

Column	Type	Description
idPK	INT	Primary key
category	VARCHAR	Product category
transaction_date	DATE	Date of transaction
amount	DECIMAL	Transaction amount

Your question is Analyze Monthly Revenue Trends by Product Category. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.