|
1
2
3
4
5
6
7
8
|
select distinct city
from station
where
right(city,1)='a' or
right(city,1)='e' or
right(city,1)='i' or
right(city,1)='o' or
right(city,1)='u'
|
cs |
반응형
'SQL' 카테고리의 다른 글
| Hacker rank Japanese Cities' Attributes (0) | 2021.10.20 |
|---|---|
| Hacker rank Weather Observation Station 8 (0) | 2021.10.20 |
| Hacker rank Weather Observation Station 6 (0) | 2021.10.20 |
| Hacker rank Weather Observation Station 5 (0) | 2021.10.20 |
| Hacker rank Weather Observation Station 4 (0) | 2021.10.20 |
댓글