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

mndev 2024. 1. 29. 10:37

문제링크

Weather Observation Station 12 | HackerRank

Query an alphabetically ordered list of CITY names not starting and 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%')
       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');