Before They Walk
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
- mid
Interview Prompt
Our retention team is convinced that most of the revenue on this book of business comes from a tiny sliver of the customer base, and they want to stand up a white-glove loyalty program aimed at exactly those people before a competitor poaches them. They have asked us to pull the ten customers who have contributed the most money across every purchase they have ever made, and to put a human-readable name next to each one so the team can actually reach out, with the biggest spenders shown first.
Summary
A few names carry the whole ledger. Reach them first, before someone else does.
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