✅ Revising Aggregations - Averages
📝 문제
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))
FROM CITY;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))
FROM CITY;