What's in a Name
A easy SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- L3
Interview Prompt
The support team noticed certain username patterns correlate with ticket volume and wants to verify a hunch. For each first letter of the username, show how many users share that initial and what percentage of the total user base they represent. Round the percentage to one decimal place and show the most common initials first.
Summary
Group by the first letter, count the heads, show the share.
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