Popular Categories
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
- L3
Interview Prompt
The merchandising team is negotiating shelf-space contracts and only wants to discuss product categories that have meaningful scale. For each category, show the number of products, the average rating, and the average price. Only include categories with more than eight products. Present them from highest average rating to lowest.
Summary
Merchandising only cares about categories big enough to negotiate shelf space.
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