Category Deep Dive

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

Domain

SQL

Difficulty

hard

Seniority

L5

Problem

Strategy wants a full financial picture per product category. For each category, compute total revenue (sum of transaction amounts) and total units sold (sum of quantities). Assign each category a position by revenue, highest first, with ties sharing a position. Return the category, revenue, units, and position.

Summary

Revenue, units, rank. The full category report card.

Practice This Problem

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