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
반응형