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
- 깃헙협업
- 온라인협업
- 코딩공부
- sql
- Git
- 선형 모형
- branch
- CSS
- github
- HTML
- PYTHON
- window function
- programmers
- AWS
- 편향-분산 교환
- 교차 엔트로피
- leetcode
- hackerrank
- elastic net
- coding
- RLIKE
- merge
- L1정규화
- conflict
- L2정규화
- 버전충돌
- early stopping
- full request
- mysql
- 클라우드컴퓨팅
Archives
- Today
- Total
Im between cherry
Hackerrank | MySQL | Weather Observation Station 4 본문
Weather Observation Station 4
Weather Observation Station 4 | HackerRank
Find the number of duplicate CITY names in STATION.
www.hackerrank.com
Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table.
The STATION table is described as follows:
Solution
SELECT COUNT(city) - COUNT(DISTINCT(city))
FROM station'데이터분석 > practice_query' 카테고리의 다른 글
| Hackerrank | MySQL | Weather Observation Station 6 (0) | 2020.08.27 |
|---|---|
| Hackerrank | MySQL | Weather Observation Station 5 (0) | 2020.08.27 |
| Hackerrank | MySQL | Weather Observation Station 3 (0) | 2020.08.27 |
| Hackerrank | MySQL | Weather Observation Station 1 (0) | 2020.08.27 |
| Hackerrank | MySQL |Japanese Cities' Names (0) | 2020.08.27 |
Comments