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

mndev 2024. 1. 29. 10:35

문제링크

Weather Observation Station 11 | HackerRank

Query a list of CITY names not starting or ending with vowels.

www.hackerrank.com

코드

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');