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')
'섭섭의 공부 > SQL' 카테고리의 다른 글
[22.01.12] HackerRank 문제 풀이 (0) | 2022.01.12 |
---|---|
[HackerRank] Weather Observation Station 12 (0) | 2021.12.25 |
[HackerRank] Weather Observation Station 10 (0) | 2021.12.25 |
[HackerRank] Weather Observation Station 9 (0) | 2021.12.25 |
[HackerRank] Weather Observation Station 8 (0) | 2021.12.25 |