Average Population of Each Continent

Sort by

recency

|

1815 Discussions

|

  • + 0 comments

    MYSQL -

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

  • + 0 comments

    select a.CONTINENT, floor(avg(b.POPULATION)) from COUNTRY as a INNER JOIN CITY as b on a.CODE = b.COUNTRYCODE group by CONTINENT;

  • + 0 comments

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

  • + 0 comments

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

  • + 0 comments

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