[HackerRank] Weather Observation Station 9 오라클 풀이

문제링크

Weather Observation Station 9 | HackerRank

 

 

 

 

코드

select distinct city
from station
where (upper(city) not like 'A%'
      and upper(city) not like 'E%'
      and upper(city) not like 'I%'
      and upper(city) not like 'O%'
      and upper(city) not like 'U%');