뉴에이지의 DATABASE

DATA SCIENCE/SQL

문제 https://www.hackerrank.com/challenges/weather-observation-station-20/problem A median is defined as a number separating the higher half of a data set from the lower half. Query the median of the Northern Latitudes (LAT_N) from STATION and round your answer to 4 decimal places. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the wester..

2021. 12. 22.

DATA SCIENCE/SQL

문제 https://www.hackerrank.com/challenges/weather-observation-station-19/problem Consider P1(a, c) and P2(b, 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. Query the Euclidean Distance between points P1 and P2 and format your..

2021. 12. 22.

DATA SCIENCE/SQL

문제 https://www.hackerrank.com/challenges/weather-observation-station-18/problem Consider P1(a, b) and P2(c, d) to be two points on a 2D plane. a happens to equal the minimum value in Northern Latitude (LAT_N in STATION). b happens to equal the minimum value in Western Longitude (LONG_W in STATION). c happens to equal the maximum value in Northern Latitude (LAT_N in STATION). d happens to equal t..

2021. 12. 22.

DATA SCIENCE/SQL

문제 https://www.hackerrank.com/challenges/weather-observation-station-17/problem Query the Western Longitude (LONG_W) where the smallest Northern Latitude (LAT_N) in STATION is greater than 38.7780. Round your answer to 4 decimal places. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. 풀이 1) LAT_N이 38.7780보다 큰 값 중 가장..

2021. 12. 22.

DATA SCIENCE/SQL

문제 https://www.hackerrank.com/challenges/weather-observation-station-16/problem Query the smallest Northern Latitude (LAT_N) from STATION that is greater than 38.7780. Round your answer to 4 decimal places. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. 풀이 1) LAT_N이 38.7780보다 큰 값 중 가장 가장 값일 때 2) LAT_N을 소수점 4째자리까지만..

2021. 12. 22.

DATA SCIENCE/SQL

문제 https://www.hackerrank.com/challenges/weather-observation-station-15/problem 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: where LAT_N is the northern latitude and LONG_W is the western longitude. 풀이 1) LAT_N이 137.2345보다 작은 값 중 ..

2021. 12. 21.

DATA SCIENCE/SQL

문제 https://www.hackerrank.com/challenges/weather-observation-station-14/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. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. 풀이 1) LAT_N의 값이 137.2345보다 작은 것들 중 2) 가장 최대인 ..

2021. 12. 21.

DATA SCIENCE/SQL

문제 https://www.hackerrank.com/challenges/weather-observation-station-13/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. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. 풀이 1) LAT_N이 38.7880보다 크고 2) 1..

2021. 12. 21.

DATA SCIENCE/SQL

문제 https://www.hackerrank.com/challenges/weather-observation-station-12/problem Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. 풀이 1) vowels(모음) 으로 시작하지 않고 (and) 2) vowels(모음) 으..

2021. 12. 21.

DATA SCIENCE/SQL

문제 https://www.hackerrank.com/challenges/weather-observation-station-11/problem 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: where LAT_N is the northern latitude and LONG_W is the western longitude. 풀이 1) vowels(모음) 으로 시작하지 않거나 (or) 2) vowels..

2021. 12. 21.

DATA SCIENCE/SQL

문제 https://www.hackerrank.com/challenges/weather-observation-station-10/problem 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: where LAT_N is the northern latitude and LONG_W is the western longitude. 풀이 1) vowels(모음) 으로 끝나지 않는 city name 리스트 중 2) 중복 없는 unique한 값 위 두 조건을 만족하는 데이터..

2021. 12. 21.

DATA SCIENCE/SQL

문제 https://www.hackerrank.com/challenges/weather-observation-station-9/problem Query the list of CITY names from STATION that do not start with vowels. Your result cannot contain duplicates. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. 풀이 1) vowels(모음) 으로 시작하지 않는 city name 리스트 중 2) 중복 없는 unique한 값 위 두 조건을 만족하는 데..

2021. 12. 21.