HACKERRANK PRACTICE SQL@Weather Observation Station 6

QUESTION

Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates.

GOOGLE翻译：
从STATION查询以元音（即a，e，i，o或u）开头的CITY名称列表。 您的结果不能包含重复项。

Input Format

The STATION table is described as follows

ANSWER

SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP ‘^ [AEIOU]’
正则表达式