Im between cherry

Hackerrank | MySQL | Weather Observation Station 16 본문

데이터분석/practice_query

Hackerrank | MySQL | Weather Observation Station 16

meal 2020. 8. 29. 11:16

Weather Observation Station 16

Problem

 

Weather Observation Station 16 | HackerRank

Query the smallest of STATION's Northern Latitudes that is greater than 38.7780, and round to 4 decimal places

www.hackerrank.com

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

 

SELECT ROUND(MIN(LAT_N),4)
FROM STATION
WHERE LAT_N > 38.7780
Comments