I get these Challenge on HackerRank
Write a query to print the list of CITY that start with vowels (a, e,
i, o, u) in lexicographical order. Do not print duplicates.
Where City like 'A%'
or City like 'E%'
or City like 'I%'
or City like 'O%'
or City like 'U%'
Order by City;
select distinct(city) from station
where upper(substr(city, 1,1)) in ('A','E','I','O','U');
Regular expressions in MySQL / MariaDB:
select distinct city from station where city regexp '^[aeiouAEIOU]' order by city