공부/PS ( SQL)
[HackerRank/Basic Select] Weather Observation Station 12
happyst
2022. 5. 16. 00:16
https://www.hackerrank.com/challenges/weather-observation-station-12/problem
Weather Observation Station 12 | HackerRank
Query an alphabetically ordered list of CITY names not starting and ending with vowels.
www.hackerrank.com
문제
풀이
SELECT DISTINCT CITY FROM STATION
WHERE CITY REGEXP "^[^aeiou]" AND CITY REGEXP "[^aeiou]$"