-
[HackerRank/Basic Select] Weather Observation Station 11공부/PS ( SQL) 2022. 5. 16. 00:13
https://www.hackerrank.com/challenges/weather-observation-station-11/problem
Weather Observation Station 11 | HackerRank
Query a list of CITY names not starting or ending with vowels.
www.hackerrank.com
문제
풀이
SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP "^[^aeiou]" OR CITY REGEXP "[^aeiou]$"
'공부 > PS ( SQL)' 카테고리의 다른 글
[HackerRank/Basic Select] Higher Than 75 Marks (0) 2022.05.16 [HackerRank/Basic Select] Weather Observation Station 12 (0) 2022.05.16 [HackerRank/Basic Select] Weather Observation Station 10 (0) 2022.05.16 [HackerRank/Basic Select] Weather Observation Station 9 (0) 2022.05.16 MYSQL 정규표현식 (0) 2022.05.15