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

문제링크

Weather Observation Station 12 | 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%')
       and 
       (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');