https://www.hackerrank.com/challenges/weather-observation-station-18/problem

 

Weather Observation Station 18 | HackerRank

Query the Manhattan Distance between two points, round or truncate to 4 decimal digits.

www.hackerrank.com

Manhattan Distance를 구하여 소수점 4자리까지 출력하는 문제 

Manhattan Distance = | x1 - x2 | + | y1 - y2 |

반응형

'지식저장소 > SQL' 카테고리의 다른 글

[SQL/MYSQL] HackerRank - Weather Observation Station 19  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 16 / 17  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 15  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 14  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 13  (0) 2022.06.10

https://www.hackerrank.com/challenges/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 38.7880. Round your answer to  4 decimal places.

Input Format

The STATION table is described as follows:

38.7880보다 큰 LAT_N 중 가장 작은 LAT_N을 반올림하여 소수점 4자리까지 출력

 

https://www.hackerrank.com/challenges/weather-observation-station-17/problem

 

Weather Observation Station 17 | HackerRank

Query the Western Longitude for the smallest value of the Northern Latitudes greater than 38.7780 in STATION and round to 4 decimal places.

www.hackerrank.com

Query the Western Longitude (LONG_W)where the smallest Northern Latitude (LAT_N) in STATION is greater than 38.7880. Round your answer to 4 decimal places.

Input Format

The STATION table is described as follows:

38.7880보다 큰 LAT_N 중 가장 작은 LAT_N의 LONG_W를 반올림하여 소수점 4자리까지 출력 

 

반응형

'지식저장소 > SQL' 카테고리의 다른 글

[SQL/MYSQL] HackerRank - Weather Observation Station 19  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 18  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 15  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 14  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 13  (0) 2022.06.10

https://www.hackerrank.com/challenges/weather-observation-station-15/problem

 

Weather Observation Station 15 | HackerRank

Query the Western Longitude for the largest Northern Latitude under 137.2345, rounded to 4 decimal places.

www.hackerrank.com

Query the Western Longitude (LONG_W) for the largest Northern Latitude (LAT_N) in STATION that is less than 137.2345. Round your answer to 4 decimal places.

Input Format

The STATION table is described as follows:

137.2345보다 작은 LAT_N 중 가장 큰 LAT_N을 가진 LONG_W를 소수점 4자리에서 반올림

반응형

'지식저장소 > SQL' 카테고리의 다른 글

[SQL/MYSQL] HackerRank - Weather Observation Station 18  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 16 / 17  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 14  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 13  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 11 / 12  (0) 2022.06.10

+ Recent posts

티스토리툴바