| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 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 |
- 파이썬 머신러닝 완벽 가이드
- 회귀분석
- 스파르타코딩
- 파이썬 철저입문
- 스파르타 코딩
- 파이썬 머신러닝 완벽가이드
- wil
- 티스토리챌린지
- 내일배움카드
- 오블완
- 프로그래머스
- TiL
- 텍스트 분석
- 스파르타
- 파이썬 철저 입문
- SQL
- 파이썬
- R
- 내일배움캠프
- 실전 데이터 분석 프로젝트
- 내일배움
- 웹 스크랩핑
- Cluster
- 프로젝트
- MySQL
- 어쩌다 마케팅
- harkerrank
- 중회귀모형
- 미세먼지
- hackerrank
- Today
- Total
목록hackerrank (6)
OkBublewrap
Weather Observation Station 11
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. 모음으로 시작하거나 끝나도 않은 것, 중복 되지 말 것 SELECT DISTINCT city FROM station WHERE city NOT REGEXP '^[aeiou].*' OR city NOT REGEXP '.*[..
Weather Observation Station 10
Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. 모음으로 끝내지 말기, 중복되지 않기 SELECT DISTINCT city FROM station WHERE city NOT REGEXP '.*[aeoiu]$' 9와 마찬가지로 정규식을 이용을 했다. "$"은 끝부분을 뜻한다.
Weather Observation Station 9
Query the list of CITY names from STATION that do not start with vowels. Your result cannot contain duplicates. Input Format The STATION table is described as follows: 모음으로 시작하지 않은 city 이름, 중복 불가 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%' NOT LIKE 연산자를 사용을 하면 된다. 정규식 연습 SELECT DISTINCT cit..
Weather Observation Station 8
Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplicates. SELECT distinct city FROM station WHERE city like 'a%a' or city like 'a%e' or city like 'a%i' or city like 'a%o' or city like 'a%u' or city like 'e%a' or city like 'e%e' or city like 'e%i' or city like 'e%o' or city like 'e%u' or ci..
Weaher Observation Station 7
Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.Input FormatThe STATION table is described as follows: SELECT distinct cityFROM stationWHERE city like '%a'or city like '%e'or city like '%i'or city like '%o'or city like '%u'모음으로 끝나는 city name만 출력, 중복된 값은 제외
Weather Observation Station 3
Query a list of CITY names from STATION for cities that have an even ID number. Print the results in any order, but exclude duplicates from the answer. The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. SELECT DISTINCT city FROM station WHERE mod(id,2) = 0 짝수인 ID number추출, 중복된 값은 제외하라