Category Deep Dive

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

Domain

SQL

Difficulty

hard

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.

Practice This Problem

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