Back Again
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
- L4
Interview Prompt
Rank users by the number of transactions they have completed, using a dense ranking so that users with equal counts share the same rank. Return the username, transaction count, and rank for users in the top 5 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 your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision