The Weight of the Cloud
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
- L4
Interview Prompt
A finance team is closing out the cloud books quarter by quarter, counting only costs billed in 2026. Weight each service's cost by every allocation booked against that same service, then report each quarter's total weighted spend, earliest quarter first.
Summary
Not every dollar counts the same. Close the quarter.
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