Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Names Grouped by Initial

Return each first letter (uppercase) and the number of names starting with it. Order by letter.

Table schema

Users(id INT PRIMARY KEY, name VARCHAR(50))

Sample data

id | name
1 | Amy
2 | Anna
3 | Ben

Discussion

No discussions yet.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.