Weather Observation Station 2 in SQL | HackerRank Solution

Hello coders, today we are going to solve Weather Observation Station 2 HackerRank Solution in SQL.

Problem

Query the following two values from the STATION table:

1. The sum of all values in LAT_N rounded to a scale of 2 decimal places.
2. The sum of all values in LONG_W rounded to a scale of 2 decimal places.

Input Format

The STATION table is described as follows:

where LAT_N is the northern latitude and LONG_W is the western longitude.

Output Format

Your results must be in the form:

``````lat lon
``````

where lat is the sum of all values in LAT_N and lon is the sum of all values in LONG_W. Both results must be rounded to a scale of 2 decimal places.

Solution – Weather Observation Station 2 in SQL

MySQL

```select round(sum(lat_n), 2), round(sum(long_w), 2)
from station;```

Disclaimer: The above Problem (Weather Observation Station 2) is generated by Hacker Rank but the Solution is Provided by CodingBroz. This tutorial is only for Educational and Learning Purpose.

7 thoughts on “Weather Observation Station 2 in SQL | HackerRank Solution”

1. Shivam Dalvi

This is the correct query.

select cast(round(sum(lat_n), 2) as decimal(10,2)),cast(round(sum(long_w), 2) as decimal(10,2))from station;

1. the syntax that he is using is T-SQL (Microsoft SQL Server)
When you ROUND() with T-SQL, it leaves trailing 0’s after the rounded number.
e.g. 120.02 vs 120.020000 where the latter answer is not correct.
He casts it as a DECIMAL(10,2) because the “2” will ensure that there will only be 2 digits after the decimal point.

1. select convert(decimal(10,2),sum(lat_n)),convert(decimal(10,2),sum(long_w)) from station

this also work

2. In MS SQL :
SELECT (CONVERT(DECIMAL(20,2),SUM(LAT_N))) AS lat, (CONVERT(DECIMAL(20,2),SUM(LONG_W))) AS lon FROM STATION