[해커랭크 / Easy] Weather Observation Station 6 (MySQL)

https://www.hackerrank.com/challenges/weather-observation-station-6/problem?isFullScreen=true 

Weather Observation Station 6 | HackerRank

STATION 테이블에서 a, e, i, o, u로 시작하는 중복되지 않게 CITY들을 출력하는 문제입니다.

 

아래는 코드입니다.

SELECT DISTINCT CITY
FROM STATION
WHERE (CITY LIKE 'a%' OR
       CITY LIKE 'i%' OR
       CITY LIKE 'o%' OR
       CITY LIKE 'u%' OR
       CITY LIKE 'e%')