Where the Money Goes
A hard 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
- hard
- Seniority
- mid
Interview Prompt
Finance is auditing cloud spend, and provider names arrive inconsistently cased across the billing exports, so the same vendor shows up under several spellings. For each provider, find the single service with the highest total cost, and show those winners with the biggest spend first.
Summary
Every provider has one service quietly eating the budget. Find it.
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