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

Count Vowels in Names

Return each name with the number of vowels (a, e, i, o, u, case-insensitive) it contains, ordered by name.

Table schema

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

Sample data

id | name
1 | Alice
2 | Bob

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.