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

|

1690 Discussions

|

  • himanshuuu_2001
     + 0 comments

    select country.continent ,floor(avg(city.population)) from city,country where city.countrycode = country.code group by country.continent

  • aslesha402
     + 0 comments

    select country.continent, floor(avg(city.population)) from city left join country on city.countrycode = country.code where country.continent is not null group by country.continent

  • pvj_valadares
     + 0 comments
    SELECT
    b.CONTINENT AS Continent,
    FLOOR(AVG(a.POPULATION)) AS media
FROM
    CITY a
    LEFT JOIN COUNTRY b
    ON UPPER(a.COUNTRYCODE) = UPPER(b.CODE)
WHERE
    b.CONTINENT IS NOT NULL
GROUP BY
    b.CONTINENT

  • loiczhu
     + 0 comments

    Spent so much time, because of a detail...

    Tip:

    [...] and their respective average city populations (CITY.Population) rounded down to the nearest integer

  • prashanthrockpr1
     + 0 comments

    select co.continent,floor(avg(c.population)) from city c,country co where c.countrycode=co.code group by co.continent