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
- full request
- 클라우드컴퓨팅
- leetcode
- github
- Git
- merge
- branch
- hackerrank
- L1정규화
- 편향-분산 교환
- 선형 모형
- AWS
- 버전충돌
- mysql
- L2정규화
- 깃헙협업
- programmers
- conflict
- 코딩공부
- HTML
- sql
- early stopping
- RLIKE
- coding
- 교차 엔트로피
- CSS
- elastic net
- window function
- PYTHON
- 온라인협업
Archives
- Today
- Total
Im between cherry
Hackerrank | MySQL | Weather Observation Station 2 본문
Weather Observation Station 2
Query the following two values from the STATION table:
- The sum of all values in LAT_N rounded to a scale of decimal places.
- The sum of all values in LONG_W rounded to a scale of decimal places.
SELECT ROUND(SUM(LAT_N),2) AS lat, ROUND(SUM(LONG_W),2) AS lon
FROM STATION
SELECT round(SUM(LAT_N),2)
,round(SUM(LONG_W),2)
FROM Station
'데이터분석 > practice_query' 카테고리의 다른 글
Hackerrank | MySQL | Weather Observation Station 14 (0) | 2020.08.29 |
---|---|
Hackerrank | MySQL | Weather Observation Station 13 (0) | 2020.08.29 |
Hackerrank | MySQL | Top Earners (0) | 2020.08.29 |
Hackerrank | MySQL | The Blunder (0) | 2020.08.28 |
Hackerrank | MySQL | Population Density Difference (0) | 2020.08.28 |
Comments