Monthly Category Totals

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

Domain

SQL

Difficulty

easy

Seniority

L5

Problem

Ahead of the holiday planning cycle, the merchandising team needs to see how each product category's revenue shifts month to month. Show the total transaction amount for each category-month combination, ordered by category then month.

Summary

Sum amounts by category and month.

Practice This Problem

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