select distinct city
from station
where right(city, 1) not in ('a','e','i','o','u')
'섭섭의 공부 > SQL' 카테고리의 다른 글
[HackerRank] Weather Observation Station 12 (0) | 2021.12.25 |
---|---|
[HackerRank] Weather Observation Station 11 (0) | 2021.12.25 |
[HackerRank] Weather Observation Station 9 (0) | 2021.12.25 |
[HackerRank] Weather Observation Station 8 (0) | 2021.12.25 |
[HackerRank] Weather Observation Station 6 (0) | 2021.12.25 |