Algorithm (131) 썸네일형 리스트형 [해커랭크(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' 출처 [해커랭크(Hacker Rank)] Revising Aggregations - Averages (MySQL) 문제 Query the average population of all cities in CITY where District is California. Input Format The CITY table is described as follows: 코드 SELECT AVG(population) FROM city WHERE district = 'California' 풀이 population의 평균 구하기 district는 California 출처 이전 1 ··· 19 20 21 22 23 24 25 ··· 33 다음
