Algorithm/MySQL (75) 썸네일형 리스트형 [해커랭크(Hacker Rank)]Population Density Difference (MySQL) 문제 Query the difference between the maximum and minimum populations in CITY. Input Format The CITY table is described as follows: 코드 SELECT MAX(population) - MIN(population) FROM city 풀이 1. population의 최댓값과 최소값 빼기 출처 [해커랭크(Hacker Rank)]Average Population (MySQL) 문제 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 ROUND(AVG(population),0) FROM city 출처 [해커랭크(Hacker Rank)]Revising Aggregations - The Count Function (MySQL) 문제 Query a count of the number of cities in CITY having a Population larger than . Input Format The CITY table is described as follows: 코드 SELECT COUNT(*) FROM city WHERE population > 100000 풀이 1. pupulation이 100000 초과 출처 [해커랭크(Hacker Rank)] Revising Aggregations - The Sum Function (MySQL) 문제 Query the total population of all cities in CITY where District is California. Input Format The CITY table is described as follows: 코드 SELECT SUM(population) FROM city WHERE district = 'California' 출처 이전 1 ··· 11 12 13 14 15 16 17 ··· 19 다음
