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

|

1794 Discussions

|

  • kirill_d1
     + 0 comments
    select COUNTRY.Continent, floor(avg(CITY.population)) from CITY join COUNTRY
  on CITY.CountryCode = COUNTRY.Code
  group by 1;

  • raksharshetty64
     + 0 comments
    SELECT CO.Continent, FLOOR(AVG(C.Population))
FROM CITY C
JOIN COUNTRY CO
    ON C.CountryCode = CO.Code
GROUP BY CO.Continent;

  • alammeraj6809
     + 0 comments

    SELECT T1.CONTINENT , FLOOR(AVG(T2.POPULATION)) AS AVERAGE_POPULATION FROM COUNTRY AS T1 JOIN CITY AS T2 ON T1.CODE = T2.COUNTRYCODE GROUP BY T1.CONTINENT

  • hikimiko01
     + 0 comments
    SELECT COUNTRY.CONTINENT, FLOOR(AVG(CITY.POPULATION))
FROM COUNTRY
JOIN CITY
ON CITY.CountryCode = COUNTRY.Code
GROUP BY COUNTRY.CONTINENT

  • nikovargas27
     + 0 comments

    MySQL:

    SELECT  
    coun.continent,
    FLOOR(AVG(city.population)) AS avg_population
FROM country coun
INNER JOIN city ON coun.code = city.countrycode
GROUP BY coun.continent;