[해커랭크] Weather Observation Station 12

문제링크 : https://www.hackerrank.com/challenges/weather-observation-station-12/problem?isFullScreen=true&h_r=next-challenge&h_v=zen

 

❓문제

Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates.

(모음으로 시작과 끝 둘 다 하면 안됨. 중복 허용 X)

Input Format

The STATION table is described as follows:

where LAT_N is the northern latitude and LONG_W is the western longitude.

 

❗답

SELECT DISTINCT CITY
FROM STATION
WHERE CITY REGEXP '^[^aeiou]' AND CITY REGEXP '[^aeiou]$'

 

---

🤔풀이

Weather Observation Station10, Weather Observation Station11과 유사 문제.