You are viewing a single comment's thread. Return to all comments →
select COUNTRY.CONTINENT, floor(avg(CITY.POPULATION)+0.5) FROM CITY , COUNTRY WHERE CITY.COUNTRYCODE=COUNTRY.CODE GROUP BY COUNTRY.CONTINENT
Seems like cookies are disabled on this browser, please enable them to open this website
Average Population of Each Continent
You are viewing a single comment's thread. Return to all comments →
select COUNTRY.CONTINENT, floor(avg(CITY.POPULATION)+0.5) FROM CITY , COUNTRY WHERE CITY.COUNTRYCODE=COUNTRY.CODE GROUP BY COUNTRY.CONTINENT