[hackerrank] Weather Observation Station 11

[hackerrank] Prepare > SQL > Basic Select >  Weather Observation Station 11

 

[문제]

 

 

[MYSQL]

 

 

[ORCALE]

select distinct(city)
from station
where not regexp_like(city,'^a|^e|^o|^u|^i','i')
or  not regexp_like(city,'a$|e$|o$|u$|i$','i');