vowels in sql

The solution for this is noted below

vowels in sql

Solution

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

Try other methods by searching on the site. That is if this doesn’t work