YUKIโs DEV BLOG ๐ป
/
Coding Test
/
SQL ์ฐ์ต ๋ฐ ์ฝ๋ฉํ ์คํธ
/
Weather Observation Station 10
Search
Share
Weather Observation Station 10
Weather Observation Station 10 | HackerRank
Query a list of CITY names not ending in vowels.
SELECT DISTINCT
(
CITY
)
FROM STATION WHERE CITY REGEXP
'.*[^AEIOUaeiou]$'
Python
๋ณต์ฌ