[해커랭크] Weather Observation Station 11&12

이전 문제 응용

 

Weather Observation Station 11

 

https://www.hackerrank.com/challenges/weather-observation-station-11/problem

Weather Observation Station 11 | HackerRank

 

 

select distinct city
from station
where city not regexp '^[aeiou]'
    or city not regexp '[aeiou]$'

 

 

 

 

 

Weather Observation Station 12

 

https://www.hackerrank.com/challenges/weather-observation-station-12/problem

Weather Observation Station 12 | HackerRank

 

select distinct city
from station
where city not regexp '^[aeiou]'   
    and city not regexp '[aeiou]$'