[MySQL] Weather Observation Station 8

[문제]

Weather Observation Station 8 | HackerRank

Weather Observation Station 8 | HackerRank

---

[문제 풀이]

Weather Observation Station 6 번 문제와 Weather Observation Station 7 번 문제를 응용해서 풀어보자.

모음으로 시작하면서 모음으로 끝나는 단어들을 찾으면 되니 (모음으로 시작하기) and (모음으로 끝나기) 형식으로 만들어보자. 

[코드]

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%') and (CITY LIKE '%a' or CITY LIKE '%e' or CITY LIKE '%i' or CITY LIKE '%o' or CITY LIKE '%u')