Metric Trend by Department
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 VP of Engineering wants a quick read on how each department's tracked metric has moved over time. For each department and fiscal_year, compute the average metric value. Return department, fiscal_year, and the average, ordered by department then year.
Summary
How each team's numbers moved, year over year.
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