Initial Count

A easy SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

easy

Problem

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.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.