Oneulog

https://www.hackerrank.com/challenges/weather-observation-station-13/problem?isFullScreen=true 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 and less than . Truncate yo..

https://www.hackerrank.com/challenges/weather-observation-station-2/problem?isFullScreen=true Weather Observation Station 2 | HackerRank Write a query to print the sum of LAT_N and the sum of LONG_W separated by space, rounded to 2 decimal places. www.hackerrank.com 문제 Query the following two values from the STATION table: The sum of all values in LAT_N rounded to a scale of decimal places. The ..

https://www.hackerrank.com/challenges/earnings-of-employees/problem?isFullScreen=true Top Earners | HackerRank Find the maximum amount of money earned by any employee, as well as the number of top earners (people who have earned this amount). www.hackerrank.com 문제 We define an employee's total earnings to be their monthly salary x months worked, and the maximum total earnings to be the maximum t..

https://www.hackerrank.com/challenges/african-cities/problem?isFullScreen=true African Cities | HackerRank Query the names of all cities on the continent 'Africa'. www.hackerrank.com 문제 Given the CITY and COUNTRY tables, query the names of all cities where the CONTINENT is 'Africa'. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. Input Format The CITY and COUNTRY tables are des..

https://www.hackerrank.com/challenges/asian-population/problem?isFullScreen=true Population Census | HackerRank Query the sum of the populations of all cities on the continent 'Asia'. www.hackerrank.com 문제 Given the CITY and COUNTRY tables, query the sum of the populations of all cities where the CONTINENT is 'Asia'. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. Input Format ..

https://www.hackerrank.com/challenges/average-population-of-each-continent/problem?isFullScreen=true Average Population of Each Continent | HackerRank Query the names of all continents and their respective city populations, rounded down to the nearest integer. www.hackerrank.com 문제 Given the CITY and COUNTRY tables, query the names of all the continents (COUNTRY.Continent) and their respective a..

https://www.hackerrank.com/challenges/the-blunder/problem?isFullScreen=true The Blunder | HackerRank Query the amount of error in Sam's result, rounded up to the next integer. www.hackerrank.com 문제 Samantha was tasked with calculating the average monthly salaries for all employees in the EMPLOYEES table, but did not realize her keyboard's key was broken until after completing the calculation. Sh..

https://www.hackerrank.com/challenges/population-density-difference/problem?isFullScreen=true Population Density Difference | HackerRank Query the difference between the maximum and minimum city populations in CITY. www.hackerrank.com 문제 Query the difference between the maximum and minimum populations in CITY. Input Format The CITY table is described as follows: Code SELECT MAX(POPULATION) - MIN..