[HackerRank] Weather Observation Station 9

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

Input Format

The STATION table is described as follows:

https://www.hackerrank.com/challenges/weather-observation-station-9/problem

where LAT_N is the northern latitude and LONG_W is the western longitude.

 

 

[My Answer]

SELECT DISTINCT CITY
FROM STATION
WHERE NOT CITY REGEXP '^[AEIOU]'

---

After seeing other blogs to review and study, it helps me when I use similar queries from the work and previous problems.