반응형
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 |