Average Population of Each Continent

Sort by

recency

|

1725 Discussions

|

  • + 0 comments

    SELECT COUNTRY.Continent, FLOOR(AVG(CITY.Population)) FROM CITY JOIN COUNTRY ON CITY.CountryCode = COUNTRY.Code GROUP BY COUNTRY.Continent

  • + 0 comments

    SELECT CN.Continent,floor(AVG(C.Population)) AS AVG_POPULATION FROM CITY C JOIN COUNTRY CN ON C.CountryCode = CN.Code group by Continent;

  • + 1 comment

    What is the necessity of using group by?

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

    SELECT CO.Continent, TRUNCATE(AVG(CI.POPULATION),0) FROM CITY AS CI INNER JOIN COUNTRY AS CO ON CI.CountryCode = CO.Code GROUP BY CO.Continent;