We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
SELECT CONTINENT, ROUND(AVG(CITY.POPULATION),0) FROM COUNTRY
JOIN
CITY ON COUNTRYCODE = CODE
GROUP BY CONTINENT;==================================Africa 274439
Asia 693038
Europe 175138
Oceania 109189
South America 147435=============
Cookie support is required to access HackerRank
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 CONTINENT, ROUND(AVG(CITY.POPULATION),0) FROM COUNTRY JOIN CITY ON COUNTRYCODE = CODE GROUP BY CONTINENT;==================================Africa 274439 Asia 693038 Europe 175138 Oceania 109189 South America 147435=============