데이터 분석 기술 블로그

Weather Observation Station 12 _ Easy. HackerRank 본문

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]$'

'SQL > 문제풀이' 카테고리의 다른 글

Higher Than 75 Marks _ Easy. HackerRank *  (0) 2024.10.15
Number of Unique Subjects Taught by Each Teacher _ Easy. LeetCode  (0) 2024.10.14
Queries Quality and Percentage _ Easy. LeetCode *  (0) 2024.10.12
Weather Observation Station 11 _ Easy. HackerRank  (0) 2024.10.11
Percentage of Users Attended a Contest _ Easy. LeetCode *  (0) 2024.10.10
'SQL/문제풀이' Related Articles more