Weather Observation Station 20
Hello Everyone!
Today I will be reviewing how I solved the Hacker Rank Challenge, Weather Observation Level Medium, using SQL.
The Objective is to Query the median of the Northern Latitudes(Lat_N) from STATION and round the answer to 4 decimal Places.
Station Table
Fields — Type
(ID — Number,
CITY — Varchar2,
STATE — Varchar2,
LAT_N — Number,
LONG_W — Number)
I used the medium function, which finds the middle values in a list of numbers. Then I used the round function to round to the nearest decimal place.
This is what the final results will look like.
select round(median(lat_n),4)
from station;
This was another fun challenge and I can’t wait to solve it using other languages. Until next time!