SESSION NAME: Advance Select - 2
QUESTION NAME: Weather Observation - Vowels TABLE DESCRIPTION: Query the list of CITY names starting 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 '^[AEIOUaeiou]' ;
0 Comments