Population Census

Sort by

recency

|

1507 Discussions

|

  • + 0 comments

    select sum(city.population) from CITY , COUNTRY where CITY.CountryCode=COUNTRY.Code and COUNTRY.CONTINENT='Asia';

  • + 0 comments

    SELECT sum(c.population) FROM CITY C INNER JOIN COUNTRY CT ON C.COUNTRYCODE = CT.CODE AND CT.CONTINENT = 'Asia'

  • + 0 comments

    sql SELECT SUM(C.Population) FROM CITY C INNER JOIN COUNTRY CO ON C.CountryCode = CO.Code WHERE CO.Continent = 'Asia';

  • + 0 comments

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

  • + 0 comments

    SELECT SUM(CITY.population) FROM CITY JOIN COUNTRY ON CITY.CountryCode = COUNTRY.Code WHERE COUNTRY.Continent ='Asia'