HackerRank-BasicSelect-Weather Observation Station 11

Weather Observation Station 11

Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.

Input Format

The STATION table is described as follows:

• 방법1

  SELECT DISTINCT CITY
  FROM STATION
  WHERE REGEXP_LIKE(CITY, '^[^AEIOU]') or REGEXP_LIKE(CITY, '[^aeiou]$');
  

• 방법2

  SELECT DISTINCT CITY
  FROM STATION
  WHERE REGEXP_LIKE(CITY, '^[^AEIOU]|[^aeiou]$');