Weather Observation Station 10 | Basic Select | SQL | HackerRank | Solution

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

Solution :

/*

Enter your query here.

*/

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