Service Budget per Head
A medium 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
- medium
- Seniority
- L4
Interview Prompt
A service's budget exposure is the dollars allocated to it, with each allocation dollar counted once for every billing line the service has. An analyst wants each service's budget per head, that exposure split evenly across its unique teams.
Summary
Budget per head. Pipeline by pipeline.
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