Weather Observation Station 2 in SQL | HackerRank Solution

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

Weather Observation Station 2

Contents

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:

FieldType
IDNUMBER
CITYVARCHAR2(21)
STATEVARCHAR2(2)
LAT_NNUMBER
Long_WNUMBER
STATION

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.

1 thought 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;

Leave a Comment

Your email address will not be published.