SQL/문제풀이

Weather Observation Station 12 _ Easy. HackerRank

데이터분석가 이채은 2024. 10. 13. 18:57

 

Solution 1

SELECT DISTINCT(CITY)
FROM STATION
WHERE CITY NOT REGEXP '^[aeiouAEIOU]'
    AND CITY NOT REGEXP '[aeiouAEIOU]$'

 

 

Solution 2

SELECT DISTINCT(CITY)
FROM STATION
WHERE CITY REGEXP '^[^aeiouAEIOU]'
    AND CITY REGEXP '[^aeiouAEIOU]$'