Interview Questions Interview Guides Experiences Mock Interviews Pricing

Interview Guides

Analyze Monthly Revenue Trends by Product Category | Dataford Interview Questions

All questions/SQL & Data Manipulation

Analyze Monthly Revenue Trends by Product Category

Medium

Problem

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

Problem

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

Practice SQL

PostgreSQL

Open on desktop for the full SQL editor with syntax highlighting and autocomplete.

Up next

Total Wine & More

Monthly Sales Trends by CategoryMedium

Wayfair

Calculate Monthly Sales Growth by Product CategoryMedium Monthly Revenue Trends by CategoryMedium