Weather Observation Station 14 in SQL | HackerRank Solution

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

Weather Observation Station 14

Problem

Query the greatest value of the Northern Latitudes (LAT_N) from STATION that is less than 137.2345. Truncate your answer to 4 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.

Solution – Weather Observation Station 14 in SQL

MySQL

select round(max(lat_n), 4) from station 
where lat_n < 137.2345;

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

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

Leave a Comment

Your email address will not be published. Required fields are marked *