혜온의 이것저것

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: 풀이 select max(population) - min(p..

https://www.hackerrank.com/challenges/japan-population/problem?isFullScreen=true&h_r=next-challenge&h_v=zen 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: 풀이 select sum(pop..

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: 풀이 select floor(avg(population)) from..

https://www.hackerrank.com/challenges/revising-aggregations-the-average-function/problem?isFullScreen=true&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Revising Aggregations - Averages | HackerRank Query the average population of all cities in the District of California. www.hackerrank.com 문제 Query the average population of all cities in CITY where District is California. Input Format T..

https://www.hackerrank.com/challenges/revising-aggregations-sum/problem?isFullScreen=true&h_r=next-challenge&h_v=zen Revising Aggregations - The Sum Function | HackerRank Query the total population of all cities for in the District of California. www.hackerrank.com 문제 Query the total population of all cities in CITY where District is California. Input Format The CITY table is described as follow..