일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | ||||||
2 | 3 | 4 | 5 | 6 | 7 | 8 |
9 | 10 | 11 | 12 | 13 | 14 | 15 |
16 | 17 | 18 | 19 | 20 | 21 | 22 |
23 | 24 | 25 | 26 | 27 | 28 | 29 |
30 | 31 |
Tags
- Selenium
- 괄호 문제
- flask
- 알고리즘
- 인스타그램
- convert to shp
- Chat-GPT
- 파이썬
- colab runtime
- geopandas
- plotly dash
- 셀레니움
- 플라스크
- string to list
- clustering
- 2164 카드2
- to shp
- python buildpacks
- 코랩 런타임
- Python
- 웹페이지
- NLP
- 해시태그
- geoDataFrame
- 크롤링
- 백준
- Merge Repositories
- Crawling
- 혁신성장부문
- kmeans
Archives
- Today
- Total
코딩코딩코딩
[HackerRank] Weather Observation Station 9 본문
-- 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 |
Comments