Monthly Running Total

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

medium

Seniority

L5

Problem

For each product, show the monthly sales total alongside a running cumulative total that accumulates across months, by product then month. Only include transactions that are attributed to a product (exclude rows with no product_id).

Summary

Cumulative sales per product across months.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.