Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Y

Question

Hacker Rank SQL problem

Answer 1

select distinct city from station
where
(city like '%a' or city like '%e' or city like '%i' or city like '%o' or city like '%u') and
(city like 'a%' or city like 'e%' or city like 'i%' or city like 'o%' or city like 'u%')

1)They are many ways to do it. I chose basic method by using wild card operators "like" '%_' for ending character and '_%' for starting character.