Creatures of Habit
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
- L4
Interview Prompt
We track every cloud cost allocation by team and service, and we're profiling the big teams: the ones that spread spend across more than three different services. For each of those teams, find the service it allocates most often, along with that allocation count.
Summary
Every big team has one service it can't quit.
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