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 revenue for a transaction is defined as the quantity sold times the listed price of the product. Order results by 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