Aggregation

Weather Observation Station 18 | HackerRank Query the Manhattan Distance between two points, round or truncate to 4 decimal digits. www.hackerrank.com 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 th..

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 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. -> lat_n 이 38.7780보다 큰 lat_n중에..

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 Problem Query the smallest Northern Latitude (LAT_N) from STATION that is greater than 38.7780 . Round your answer to 4 decimal places. -> 38.7780 보다 큰 lat_n 중에서 가장 작은 값을 소수점 4자리에서 반올림하여 출력하시오. Answer select round(min(lat_n)..

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 ..

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..

Weather Observation Station 10 | HackerRank Query a list of CITY names not ending in vowels. www.hackerrank.com Problem Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates. -> 모음으로 끝나지 않는 도시 이름을 중복 없이 출력하시오. Answer select distinct(city) from station where city regexp "[^aeiou]$"

Weather Observation Station 8 | HackerRank Query CITY names that start AND end with vowels. www.hackerrank.com Problem Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplicates. -> station에서 처음과 마지막 문자로 모두 모음이 있는 CITY 이름 목록을 중복 없이 출력하시오. Answer select distinct(city) from station where city ..

Weather Observation Station 7 | HackerRank Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. www.hackerrank.com Problem Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates. -> station에서 모음(a, e, i, o, u)으로 끝나는 CITY 이름을 중복 없이 출력하시오. Answer select distinct(city) from station where city regexp "[aeiou]$"