Loading interview...

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

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.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your sql solution with real code execution
  4. Get instant feedback and a hire/no-hire decision