SELECT DISTINCT CITY FROM STATION WHERE UPPER(SUBSTR(CITY, -1, 1)) IN ('A', 'E', 'I', 'O', 'U');

Alternative Approach Using REGEXP You can also use the REGEXP operator for a more concise solution:

SELECT DISTINCT city FROM STATION WHERE city REGEXP '[aeiou]$';

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';

select distinct city from station where right(city,1) in ('a','e','i','o','u');

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';

select distinct(CITY) FROM STATION

WHERE SUBSTRING(CITY,len(city),len(city)) IN ('a','e','i','o','u')