Department Running Totals
A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L5
Interview Prompt
Ahead of the annual budget cycle, the CFO wants to see how each department's metric values accumulate quarter over quarter. Return every metric record with an additional column showing the running total of metric_value within each department, sequenced by fiscal year and quarter.
Summary
Compute cumulative metric values within each department using window operations.
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