Before They Walk
A medium 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
- medium
- Seniority
- mid
Interview Prompt
Most of the revenue in `transactions` seems to come from a tiny sliver of customers, and the retention team wants a white-glove loyalty program for exactly those people before a competitor poaches them. Find the ten customers who have spent the most, showing each one's user ID, `username` from `users`, and total spend, biggest spenders 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 and run your SQL against a real database
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision