[해커랭크 SQL] Basic Select - Weather Observation Station 6

❓ Question

https://www.hackerrank.com/challenges/weather-observation-station-6

Weather Observation Station 6 | HackerRank

❗ Answer

SELECT DISTINCT(city)
    FROM station
    WHERE LEFT(city,1) IN ('a','e','i','o','u');

📌 Discussion

- LEFT(column,num)으로 왼쪽부터 num번째까지의 데이터를 추출

- a IN b 으로 b안에 a가 있는 레코드만 추출