Top Per Category
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
- L4
Interview Prompt
Editorial wants to feature the top-rated product in every category. Within each category, find the product(s) with the highest rating and include all ties. Skip products with no rating. Return the product_name, category, and rating.
Summary
Every category has a champion. Crown them all.
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