Hackerrank

[Hackerrank SQL] Weather Observation Station 13

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 연산에 관한 문제이다. select truncate(sum(LAT_N),4) from STATION WHERE LAT_N > 38.7880 AND lat_n

[Hackerrank SQL] Weather Observation Station 5

www.hackerrank.com/challenges/weather-observation-station-5/problem?h_r=next-challenge&h_v=zen Weather Observation Station 5 | HackerRank Write a query to print the shortest and longest length city name along with the length of the city names. www.hackerrank.com Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characte..

[Hackerrank SQL] Weather Observation Station 3

www.hackerrank.com/challenges/weather-observation-station-3/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Weather Observation Station 3 | HackerRank Query a list of unique CITY names with even ID numbers. www.hackerrank.com Query a list of CITY na..