[SQL][HackerRank] Weather Observation Station 10

https://www.hackerrank.com/challenges/weather-observation-station-10/problem?h_r=next-challenge&h_v=zen

Weather Observation Station 10 | HackerRank

• query CITY names ==> SELECT CITY
• from STATION table ==> FROM STATION
• do not end with vowels ==> WHERE CITY REGEXP ‘[^aeiou]$’
• do not contain duplicates ==> SELECT DISTINCT CITY

select distinct city 
from station
where city regexp '[^aeiou]$';