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