SQL/문제풀이

Weather Observation Station 11 _ Easy. HackerRank

데이터분석가 이채은 2024. 10. 11. 13:12

 

Solution1

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

 

Solution 2

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