Population Census

Sort by

recency

|

1517 Discussions

|

  • + 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'
    
  • + 0 comments

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

  • + 0 comments

    MySQL - select sum(city.population) from city inner join country on country.code = city.countrycode where country.continent = 'Asia';