HackerRank-Weather observation station-6, 7

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

Weather Observation Station 6 | HackerRank

[문제의 조건]

- 역 이름이 a,e,i,o,u 로 시작하는 역 이름을 가져올 것

- 중복된 역 이름을 가져오지 말 것.

 

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%')

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

Weather Observation Station 7 | HackerRank

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')

앞선 문제를 거꾸로 표기한 것에 지나지 않는다. 와일드카드 문자를 숙지하자