Normalization Tradeoffs in Practice
A hard SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- hard
- Seniority
- L5
Interview Prompt
The finance team needs total revenue per product category, where a transaction's revenue is the quantity sold times the product's listed price. Give them the total revenue for each category.
Summary
Clean data or fast queries? You can't always have both.
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