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.
  1. Prepare
  2. SQL
  3. Basic Join
  4. Average Population of Each Continent
  5. Discussions

Average Population of Each Continent

Sort by

recency

|

1810 Discussions

|

  • hatrangqluu
     + 0 comments
     SELECT ctr.continent
, sum(ct.population) div count(ct.name) as avg_city_population
from city ct
join country ctr 
on ct.countrycode = ctr.code
GROUP BY ctr.continent;

  • borasarthak275
     + 0 comments

    SELECT COUN.CONTINENT,FLOOR(AVG(CIT.POPULATION)) FROM COUNTRY COUN JOIN CITY CIT ON CIT.COUNTRYCODE = COUN.CODE GROUP BY COUN.CONTINENT; USING ROUND IN PLACE OF FLOOR PRODUCES ERROR I MEAN BOTH DOES THE SAME THING

  • ryansicy07
     + 0 comments

    SELECT country.continent, floor(avg(city.population)) from country join city on city.countrycode = country.code group by country.continent having avg(city.population) is not null order by avg(city.population);

  • akashrawat27
     + 0 comments

    SELECT b1.continent, floor(avg(a1.POPULATION)) FROM CITY a1 right JOIN COUNTRY b1 ON a1.COUNTRYCODE = b1.CODE where b1.continent != 'null' and a1.POPULATION != 'null' GROUP BY b1.CONTINENT

    using right join

  • patilprathames25
     + 0 comments

    SELECT b1.CONTINENT,FLOOR(AVG(a1.POPULATION)) FROM CITY a1 INNER JOIN COUNTRY b1 ON a1.CountryCode = b1.Code GROUP BY b1.CONTINENT