search

akmalist / HackerRank

Playground for HackerRank
0 stars 0 forks source link

Weather Observation Station 16 #11

Open akmalist opened 5 years ago

akmalist commented 5 years ago

Query the smallest Northern Latitude (LAT_N) from STATION that is greater than 38.7780 . Round your answer to 4 decimal places.

Select CAST(min(LAT_N) as decimal(10, 4))
From STATION
Where lat_n > 38.7780;
akmalist commented 5 years ago

Select Convert(Decimal(20,4),min(LAT_N)) from STATION WHERE LAT_N > 38.7780;

akmalist commented 5 years ago

SELECT cast (ROUND(MIN(Lat_N), 4) as decimal (10,4)) FROM Station WHERE Lat_N > 38.7780;