Point of Entry
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
The growth team is checking whether the people who arrive and simply look around ever turn into buyers. For every user whose very first recorded event was a page view, count how many purchases they later made, and keep the ones who never bought with a count of zero. Order the result from the most purchases down, breaking ties by user ID ascending.
Summary
Everyone starts by looking. Count who came back to buy.
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