Back Again
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
- L4
Interview Prompt
Each user with completed transactions sits in a tier by how many they completed, the busiest at the top. Return each user's name, their completed transaction count and their tier, keeping only the top two tiers.
Summary
Acquisition is expensive. These customers didn't need convincing twice.
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