Monthly Category Totals
A easy SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- L5
Interview Prompt
Ahead of the holiday planning cycle, the merchandising team needs to see how each product category's revenue shifts month to month. Show the total transaction amount for each category-month combination, ordered by category then month.
Summary
Sum amounts by category and month.
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