https://www.hackerrank.com/challenges/weather-observation-station-2/problem?isFullScreen=true
Weather Observation Station 2 | HackerRank
Write a query to print the sum of LAT_N and the sum of LONG_W separated by space, rounded to 2 decimal places.
www.hackerrank.com
코드설명
ROUND + SUM을 활용합니다.
ORACLE 코드
SELECT ROUND(SUM(LAT_N), 2), ROUND(SUM(LONG_W), 2)
FROM STATION;'SQL > HackerRank' 카테고리의 다른 글
| [SQL][HackerRank] Weather Observation Station 2 - ROUND + BETWEEN ORACLE (0) | 2024.10.04 |
|---|---|
| [SQL][HackerRank] Top Earners - GROUP BY + ROWNUM ORACLE (0) | 2024.10.04 |
| [SQL][HackerRank] The Blunder - AVG + REPLACE + ROUND + 올림처리 ORACLE (0) | 2024.10.03 |
| [SQL][HackerRank] Population Density Difference - MAX + MIN ORACLE (0) | 2024.10.03 |
| [SQL][HackerRank] Japan Population - SUM ORACLE (0) | 2024.10.03 |