Weather Observation - Start - Advance Select - 1

Guywithnojob March 03, 2021

SESSION NAME: Advance Select - 1

QUESTION NAME: Weather Observation - Start.

TABLE DESCRIPTION:

Query the list of CITY names from STATION which have

vowels (i.e., a, e, i, o, and u) as first characters.

Your result cannot contain duplicates.

CODE:

select DISTINCT CITY from STATION where CITY RLIKE '^[AEIOUaeiou]';