Population Census

Sort by

recency

|

1391 Discussions

|

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

    mySQL

  • + 0 comments

    select sum(C.population) from City as C inner join Country as E on C.CountryCode=E.Code where continent='Asia'

  • + 0 comments

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

  • + 0 comments

    My sql

    select

    sum(c.POPULATION)as ans

    from

    CITY c join COUNTRY CO on c.COUNTRYCODE=CO.CODE

    where

    CO.CONTINENT='Asia'

  • + 0 comments

    Note that is a default inner join

    select SUM(_city.population) from city _city, country _country 
    where _city.countrycode = _country.code and _country.continent='Asia'