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
The transactions table contains duplicate records. First deduplicate by keeping only the first occurrence of each transaction (the one with the lowest transaction_id when multiple rows share the same user_id, product_id, total_amount, and transaction_date). Then combine with the products table and compute the total sales amount per product category, only counting transactions where total_amount is positive.
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