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 |
Tags
- elastic net
- early stopping
- 깃헙협업
- mysql
- hackerrank
- branch
- L2정규화
- Git
- 버전충돌
- coding
- 온라인협업
- merge
- PYTHON
- full request
- 코딩공부
- programmers
- HTML
- RLIKE
- leetcode
- 클라우드컴퓨팅
- sql
- CSS
- L1정규화
- 교차 엔트로피
- window function
- 선형 모형
- conflict
- AWS
- github
- 편향-분산 교환
Archives
- Today
- Total
Im between cherry
Hackerrank | MySQL | Weather Observation Station 13 본문
Weather Observation Station 13
Weather Observation Station 13 | HackerRank
Query the sum of Northern Latitudes having values greater than 38.7880 and less than 137.2345, truncated to 4 decimal places.
www.hackerrank.com
Query the sum of Northern Latitudes (LAT_N) from STATION having values greater than and less than . Truncate your answer to decimal places.
SELECT round(SUM(Lat_n),4)
FROM Station
WHERE Lat_n Between 38.7880 and 137.2345SELECT TRUNCATE(SUM(LAT_N), 4)
FROM STATION
WHERE LAT_N > 38.7880 AND LAT_N < 137.2345'데이터분석 > practice_query' 카테고리의 다른 글
| Hackerrank | MySQL | Weather Observation Station 15 (0) | 2020.08.29 |
|---|---|
| Hackerrank | MySQL | Weather Observation Station 14 (0) | 2020.08.29 |
| Hackerrank | MySQL | Weather Observation Station 2 (0) | 2020.08.29 |
| Hackerrank | MySQL | Top Earners (0) | 2020.08.29 |
| Hackerrank | MySQL | The Blunder (0) | 2020.08.28 |