Category Census
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 warehouse team is prepping inventory numbers for the quarterly review. They need to see how many products sit in each category, but only categories that carry more than eight items are worth discussing. Show the category and the product tally, sorted from largest category to smallest.
Summary
Which aisles are worth restocking?
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