Population Census

Sort by

recency

|

1500 Discussions

|

  • + 0 comments

    select sum(city.population) from city join country on city.contrycode = country.code where country.continent = 'Asia';

  • + 0 comments

    MS SQL Server

    SELECT SUM(cc.population) FROM country c INNER JOIN city cc ON c.code= cc.countrycode WHERE continent ="Asia";

  • + 0 comments

    select sum(ci.population) from city ci join country co on ci.countrycode=co.code where co.continent="asia";

  • + 0 comments
    SELECT SUM(CITY.Population)
    FROM CITY
    JOIN COUNTRY
    ON CITY.CountryCode = COUNTRY.Code
    WHERE COUNTRY.Continent = 'Asia';
    
  • + 0 comments

    My answer:

    SELECT SUM(CITY.POPULATION)
    FROM CITY
    JOIN COUNTRY
    ON CITY.COUNTRYCODE = COUNTRY.CODE
    WHERE COUNTRY.CONTINENT = 'Asia';