-
[HackerRank/Basic Select] Weather Observation Station 12공부/PS ( SQL) 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]$"
'공부 > PS ( SQL)' 카테고리의 다른 글
[HackerRank/Basic Select] Employee Names (0) 2022.05.16 [HackerRank/Basic Select] Higher Than 75 Marks (0) 2022.05.16 [HackerRank/Basic Select] Weather Observation Station 11 (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