TECH

Weather Observation Station 12

AKA.DM 2022. 6. 13. 08:02
반응형

Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates.

Input Format

The STATION table is described as follows:

select distinct city
from station
where
    not regexp_like(city, '^[aeiou]', 'i') 
    and 
    not regexp_like(city, '[aeiou]$', 'i');
반응형

'TECH' 카테고리의 다른 글

Weather Observation Station 16  (0) 2022.06.20
Higher Than 75 Marks  (0) 2022.06.15
Weather Observation Station 11  (0) 2022.06.10
Weather Observation Station 10  (0) 2022.06.10
Weather Observation Station 9  (0) 2022.06.10