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:

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

*조건 : CITY를 가져와라

단, 중복은 안되고 AEIOU로 시작해서도 안된다.

 

select distinct city
from station
where substr(city,1,1) not in ('A','E','I','O','U') ;

 

MYSQL은 WHERE  CITY REGEXP '^[^AEIOU] '