|
1
2
3
4
5
|
select distinct city
from station
where
left(city,1) not in ('a','e','i','o','u') or
right(city,1) not in ('a','e','i','o','u')
|
cs |
반응형
'SQL' 카테고리의 다른 글
| Hacker rank Higher Than 75 Marks (0) | 2021.10.21 |
|---|---|
| Hacker rank Weather Observation Station 12 (0) | 2021.10.21 |
| Hacker rank Weather Observation Station 10 (0) | 2021.10.20 |
| Hacker rank Weather Observation Station 9 (0) | 2021.10.20 |
| Hacker rank Japanese Cities' Attributes (0) | 2021.10.20 |
댓글