Weather Observation - Vowels Start and End - Advance Select - 1.

SESSION NAME: Advance Select - 1

QUESTION NAME: Weather Observation - Vowels Start and End.

TABLE DESCRIPTION:

Query the list of CITY names from STATION which have

vowels (i.e., a, e, i, o, and u) as both their first and last 

characters. Your result cannot contain duplicates.

CODE:

SELECT DISTINCT CITY FROM STATION

WHERE CITY RLIKE '^[AEIOUaeiou].*[aeiouAEIOU]$';