What's in a Name

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

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

We want a breakdown of the user base by the first letter of each username. For every initial, show how many users share it and what percentage of all users that represents, rounded to one decimal place, with the most common initials first.

Summary

The first letter is a fingerprint. Read the crowd by it.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and checks it automatically.