Names Grouped by Initial
Easy
Text Analysis in SQL
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.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.