search

akmalist / HackerRank

Playground for HackerRank
0 stars 0 forks source link

Weather Observation Station 14 #9

Open akmalist opened 5 years ago

akmalist commented 5 years ago

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.

Select CAST(Max(LAT_N) as numeric(10, 4))
From STATION
Where lat_n <137.2345;