Clean Averages
An easy SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- L3
Interview Prompt
The merchandising team is benchmarking product quality across the catalog. For each category with at least three rated products, give how many rated products it has and their average customer rating.
Summary
Merchandising only cares about the categories customers actually rate.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write and run your SQL against a real database
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision