Notice
Recent Posts
Recent Comments
Link
| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 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
- leetcode
- branch
- HTML
- 코딩공부
- programmers
- window function
- elastic net
- PYTHON
- 깃헙협업
- 온라인협업
- 선형 모형
- CSS
- L2정규화
- 편향-분산 교환
- early stopping
- merge
- L1정규화
- AWS
- mysql
- 버전충돌
- github
- coding
- 클라우드컴퓨팅
- Git
- conflict
- full request
- hackerrank
- RLIKE
- sql
- 교차 엔트로피
Archives
- Today
- Total
Im between cherry
Hackerrank | MySQL | Weather Observation Station 3 본문
Weather Observation Station 3
Weather Observation Station 3 | HackerRank
Query a list of unique CITY names with even ID numbers.
www.hackerrank.com
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:
Solution
SELECT distinct City
FROM Station
WHERE ID % 2 = 0'데이터분석 > practice_query' 카테고리의 다른 글
| Hackerrank | MySQL | Weather Observation Station 5 (0) | 2020.08.27 |
|---|---|
| Hackerrank | MySQL | Weather Observation Station 4 (0) | 2020.08.27 |
| Hackerrank | MySQL | Weather Observation Station 1 (0) | 2020.08.27 |
| Hackerrank | MySQL |Japanese Cities' Names (0) | 2020.08.27 |
| Hackerrank | MySQL | Japanese Cities' Attributes (0) | 2020.08.27 |
Comments