Metric Range Per Group
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
- L5
Interview Prompt
HR suspects some departments have much wider performance variance than others. For each department, compute the spread between its highest and lowest metric values, ordered alphabetically by department.
Summary
The spread within each group.
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