Weather Observation Station 9 / HackerRank, SQL, MySQL

문제

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:

 

제출답안(MySQL)

SELECT DISTINCT(city) FROM station
WHERE city REGEXP '^[^aeiou]'

 

 

 

풀이(MySQL)

MySQL 정규표현식 참고자료

 

 

 

문제 바로가기(MySQL)