본문 바로가기
DB/SQL

HackerRank_08. Weather Observation Station 2

by _S0_H2_ 2020. 6. 11.
728x90
반응형

문제 :

Query the following two values from the STATION table:

  1. The sum of all values in LAT_N rounded to a scale of  decimal places.
  2. 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
반응형