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