Two Sides of the Ledger
A hard SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- hard
- Seniority
- L5
Interview Prompt
The FinOps team wants to reconcile actual cloud charges against budget allocations on a per-region timeline. Stack both sources together, treating charges as negative and allocations as positive, and compute a running balance per region. Return region, date, amount, and running balance, sequenced by region and date.
Summary
Two cost tables, one region. Which way does the balance tip?
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