sql notes: hackerrank average population

Problem

Query the average population for all cities in CITY, rounded down to the nearest integer.

Input Format
The CITY table is described as follows:

Analysis

• query average population ==> SELECT AVG(POPULATION)
• round down to the nearest integer ==> SELECT ROUND(AVG(POPULATION))
• in CITY table ==> FROM CITY

Solution

1

SELECT ROUND(AVG(POPULATION)) FROM CITY;

Link

Average Population
(中文版) SQL 笔记: Hackerrank Average Population