Category Revenue
A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L3
Interview Prompt
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.
Summary
Which categories pull their weight?
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision