[SQL] Weather Observation Station 12

문제

Query the list of CITY names from STATION that do not start with vowels and do not end 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.

정답

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%'
AND CITY NOT LIKE '%a'
AND CITY NOT LIKE '%e'
AND CITY NOT LIKE "%i"
AND CITY NOT LIKE "%o"
AND CITY NOT LIKE "%u";