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

|

1701 Discussions

|

  • oswal_shrutika_1
     + 0 comments

    select country.continent , FLOOR(AVG(city.population)) from country join city on country.code = city.countrycode group by country.continent

  • GayatriNaregal
     + 0 comments

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

  • vennelasai043
     + 0 comments

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

  • vennelasai043
     + 0 comments

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

  • kranand_vnit
     + 1 comment

    SELECT FLOOR(AVG(CT.POPULATION)) , CR.CONTINENT FROM CITY CT JOIN COUNTRY CR ON CT.COUNTRYCODE = CR.CODE GROUP BY CR.CONTINENT ORDER BY CR.CONTINENT;

    I wrote this query I am unable to get the issue in the query as it is saying result is not correct