TRUNCATE 썸네일형 리스트형 [HackerRank][SQL][Aggregation] Weather Observation Station 19 - 컴도리돌이 Weather Observation Station 19 | HackerRank Query the Euclidean Distance between two points and round to 4 decimal digits. www.hackerrank.com Problem Consider P1(a,b) and P2(c,d) to be two points on a 2D plane where (a,b) are the respective minimum and maximum values of Northern Latitude (LAT_N) and (c,d) are the respective minimum and maximum values of Western Longitude (LONG_W) in STATION. Que.. 더보기 [HackerRank][SQL] Weather Observation Station 14 - 컴도리돌이 Weather Observation Station 14 | HackerRank Query the greatest value of the Northern Latitudes from STATION that are under 137.2345 and truncated to 4 decimal places. www.hackerrank.com 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. -> lat_n이 137.2345 보다 작은 값중에서 제일 큰 값을 소수점 4자리로 출력하시오. Answer .. 더보기 [HackerRank][SQL] Weather Observation Station 13 - 컴도리돌이 Weather Observation Station 13 | HackerRank Query the sum of Northern Latitudes having values greater than 38.7880 and less than 137.2345, truncated to 4 decimal places. www.hackerrank.com Problem Query the sum of Northern Latitudes (LAT_N) from STATION having values greater than 38.7880 and less than 137.2345 . Truncate your answer to 4 decimal places. -> 38.7880보다 크고 137.2345보다 작은 값을 가진 STATIO.. 더보기 이전 1 다음
