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:

 

 

 

 

 

 

# 나의 해답

 

SELECT DISTINCT CITY
FROM STATION
WHERE CITY NOT LIKE ('A%')
AND CITY NOT LIKE ('E%')
AND CITY NOT LIKE ('I%')
AND CITY NOT LIKE ('O%')
AND CITY NOT LIKE ('U%');