DB/SQL
HackerRank_08. Weather Observation Station 2
_S0_H2_
2020. 6. 11. 21:48
728x90
반응형
문제 :
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;
42850.04 47381.48
728x90
반응형