코딩코딩코딩

[HackerRank] Weather Observation Station 9 본문

MySQL/Problem Solving

[HackerRank] Weather Observation Station 9

hanshow113 2022. 1. 9. 20:48 

-- NOT LIKE 연산자 사용
SELECT DISTINCT(CITY)
FROM STATION
WHERE CITY NOT LIKE "a%"
AND CITY NOT LIKE "e%"
AND CITY NOT LIKE "i%"
AND CITY NOT LIKE "o%"
AND CITY NOT LIKE "u%";

-- REGEXP 사용
SELECT DISTINCT(CITY)
FROM STATION
WHERE CITY NOT REGEXP "^[aeiou]";

'MySQL > Problem Solving' 카테고리의 다른 글

[HackerRank] Higher Than 75 Marks  (0) 2022.01.10
[HackerRank] Employee Salaries  (0) 2022.01.10
[HackerRank] Employee Names  (0) 2022.01.10
[HackerRank] Weather Observation Station 12  (0) 2022.01.09
[HackerRank] Weather Observation Station 11  (0) 2022.01.09
'MySQL/Problem Solving' Related Articles more
Comments