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

문제링크

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