|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
select distinct city
from station
where(
left(city,1)='a' or
left(city,1)='e' or
left(city,1)='i' or
left(city,1)='o' or
left(city,1)='u'
) and
(
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 Weather Observation Station 9 (0) | 2021.10.20 |
|---|---|
| Hacker rank Japanese Cities' Attributes (0) | 2021.10.20 |
| Hacker rank Weather Observation Station 7 (0) | 2021.10.20 |
| Hacker rank Weather Observation Station 6 (0) | 2021.10.20 |
| Hacker rank Weather Observation Station 5 (0) | 2021.10.20 |
댓글