Weather Observation - Vowels Ending - Advance Select - 1

Guywithnojob March 03, 2021

SESSION NAME: Advance Select - 1

QUESTION NAME: Weather Observation - Vowels Ending

TABLE DESCRIPTION:

Query the list of CITY names ending with vowels (i.e., a, e,

i, o, or u) from STATION. Your result cannot contain

duplicates.

CODE:

select DISTINCT CITY from STATION where CITY RLIKE '[aeiou]$';