Weather Observation Station 7 | Basic Select | SQL | Practice | HackerRank | Solution

 

Problem : https://www.hackerrank.com/challenges/weather-observation-station-7/problem

Solution : 

/*

Enter your query here.

*/

SELECT DISTINCT CITY FROM STATION WHERE RIGHT(CITY,1) IN ('a','e','i','u','o');