Loading interview...

Initial Count

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

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.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your sql solution with real code execution
  4. Get instant feedback and a hire/no-hire decision