Query the following two values from the STATION table:
- The sum of all values in LAT_N rounded to a scale of 2 decimal places.
- The sum of all values in LONG_W rounded to a scale of 2 decimal places.
The STATION table is described as follows:
where LAT_N is the northern latitude and LONG_W is the western longitude.
Your results must be in the form:
where is the sum of all values in LAT_N and is the sum of all values in LONG_W. Both results must be rounded to a scale of decimal places.
Weather Observation Station 2 sql – Hacker Rank Solution
SELECT ROUND(SUM(LAT_N), 2), ROUND(SUM(LONG_W), 2) FROM STATION;
Disclaimer: The above Problem (Weather Observation Station 2 ) generated by Hackerrank but the Solution is Provided by codeworld19. This tutorial is only for Educational and Learning purposes. Authority if any of the queries regarding this post or website fill the following contact form thank you.