[SQL] Weather Observation Station 6

문제

Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. 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 LIKE'a%' 
OR CITY LIKE'e%' 
OR CITY LIKE'i%' 
OR CITY LIKE'o%'
OR CITY LIKE'u%';