Category Revenue

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

Domain

SQL

Difficulty

medium

Problem

The finance team is building a category performance dashboard for the quarterly business review. For each product category, they need the total revenue generated, the number of transactions that drove it, and the average transaction size. Only include categories that have crossed a meaningful revenue threshold , anything below 500 in total revenue isn't worth a line on the slide. Rank from highest-revenue category to lowest.

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.