[MySQL] Weather Observation Station 12

[문제]

Weather Observation Station 12 | HackerRank

Weather Observation Station 12 | HackerRank

---

[문제 풀이]

Weather Observation Station 11 문제와 비슷한 유형이다.

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