The Ones Who Return
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
Our member growth team is prepping the quarterly retention review and wants a single number for how top-heavy the buying really is: the members who shop more often than the average customer are the ones carrying the business. Give the share of the member base that makes more purchases than the average member.
Summary
One purchase is a trial. Two is a habit. Find how many members formed one.
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