SQL
Hacker rank Weather Observation Station 8
무적김두칠
2021. 10. 20. 21:54
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 |
반응형