select DISTINCT CITY
FROM STATION
where LEFT(CITY,1) in ('a', 'e', 'i', 'o', 'u');
'Algorithm > SQL' 카테고리의 다른 글
[SQL][HackerRank] Weather Observation Station 9 (0) | 2020.06.09 |
---|---|
[SQL][HackerRank] Weather Observation Station 8 (0) | 2020.06.08 |
[SQL][HackerRank] Weather Observation Station 5 (0) | 2020.06.08 |
[SQL][HackerRank] Weather Observation Station 4 (0) | 2020.06.08 |
[SQL][HackerRank] Weather Observation Station 3 (0) | 2020.06.08 |