[MySQL] Weather Observation Station 11

[문제]

Weather Observation Station 11 | HackerRank

Weather Observation Station 11 | HackerRank

---

[문제 풀이]

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

단, Not like 를 사용하니 기존 방식과 and 와 or 의 위치가 살짝씩 수정이 된다.

---

[코드]

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