select distinct city
from station
where left(city, 1) not in ('a','e','i','o','u')
and right(city, 1) not in ('a','e','i','o','u')'섭섭의 공부 > SQL' 카테고리의 다른 글
| [22.01.15] HackerRank 문제 풀이 (0) | 2022.01.15 |
|---|---|
| [22.01.12] HackerRank 문제 풀이 (0) | 2022.01.12 |
| [HackerRank] Weather Observation Station 11 (0) | 2021.12.25 |
| [HackerRank] Weather Observation Station 10 (0) | 2021.12.25 |
| [HackerRank] Weather Observation Station 9 (0) | 2021.12.25 |