You are viewing a single comment's thread. Return to all comments →
SELECT co.continent, TRUNC(AVG(c.population)) FROM city c JOIN COUNTRY co ON c.countrycode = co.code GROUP BY co.continent;
Average Population of Each Continent
You are viewing a single comment's thread. Return to all comments →
SELECT co.continent, TRUNC(AVG(c.population)) FROM city c JOIN COUNTRY co ON c.countrycode = co.code GROUP BY co.continent;