Milky's note

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 0 key was broken until after completing the calculation..

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: [답] -mysql select max(populatio..

https://www.hackerrank.com/challenges/japan-population/problem?isFullScreen=true Japan Population | HackerRank Query to the sum of the populations of all Japanese cities in CITY. www.hackerrank.com [문제] Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is JPN. Input Format The CITY table is described as follows: [답] -mysql select sum(population) from cit..

https://www.hackerrank.com/challenges/average-population/problem?isFullScreen=true Average Population | HackerRank Query the average population of all cities, rounded down to the nearest integer. www.hackerrank.com [문제] Query the average population for all cities in CITY, rounded down to the nearest integer. Input Format The CITY table is described as follows: [답] -mysql select round(avg(populat..