The Clean Aisle Numbers
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
- L5
Interview Prompt
Our transactions log has accumulated duplicate rows over time. Collapse each transaction to a single record, then combine it with the product catalog to report the total sales amount for each product category.
Summary
Clear the noise. What did each category actually earn?
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