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

 

Weather Observation Station 19 | HackerRank

Query the Euclidean Distance between two points and round to 4 decimal digits.

www.hackerrank.com

Euclidean 거리를 구하여 소수점 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 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-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

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

 

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

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.

Input Format

The STATION table is described as follows:

137.2345 보다 작은 LAT_N 중 가장 큰 LAT_N을 소수점 4자리까지 표현

반응형

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

[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 13  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 11 / 12  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 10  (0) 2022.06.10

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

 

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

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.

Input Format

The STATION table is described as follows:

 

LAT_N이 38.7880 보다 크고 137.2345 보다 작은 수들의 합을 구하고 소수점 4째짜리 까지 표현하는 문제

 

반응형

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

[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 11 / 12  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 10  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 9  (0) 2022.06.10

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

 

Weather Observation Station 10 | HackerRank

Query a list of CITY names not ending in vowels.

www.hackerrank.com

Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.

Input Format

The STATION table is described as follows:

a,e,i,o,u로 시작하지 않거나 a,e,i,o,u로 끝나지 않는 CITY를 찾는 문제

 

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

 

Weather Observation Station 12 | HackerRank

Query an alphabetically ordered list of CITY names not starting and ending with vowels.

www.hackerrank.com

a,e,i,o,u로 시작하지 않고 a,e,i,o,u로 끝나지 않는 CITY를 찾는 문제

반응형

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

[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 10  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 9  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 8  (0) 2022.06.10

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

 

Weather Observation Station 9 | HackerRank

Query an alphabetically ordered list of CITY names not starting with vowels.

www.hackerrank.com

Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates.

Input Format

The STATION table is described as follows:

 

a,e,i,o,u 로 끝나지 않는 CITY 찾기

반응형

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

[SQL/MYSQL] HackerRank - Weather Observation Station 13  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 11 / 12  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 9  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 8  (0) 2022.06.10
[SQL/MYSQL] HackerRank - Weather Observation Station 7  (0) 2022.06.10

+ Recent posts

티스토리툴바