Population Census

Sort by

recency

|

1519 Discussions

|

  • + 0 comments

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

  • + 0 comments

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

  • + 0 comments

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

  • + 0 comments

    select sum(a.POPULATION) from CITY as a LEFT JOIN COUNTRY as b ON a.COUNTRYCODE = b.CODE where b.CONTINENT = 'Asia';

  • + 0 comments
    select
    sum(city.population)
    from city inner join country on city.countrycode = country.code
    where country.continent = 'Asia'