Discussion on Population Census Challenge

recency

39 minutes ago+ 0 comments

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

2 days ago+ 0 comments

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

4 days ago+ 0 comments

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

4 days ago+ 0 comments

select sum(c.population) from city c join country cn on c.CountryCode = cn.Code where cn.continent='Asia';

5 days ago+ 0 comments

I am just trying out LIKE in this code snippet

SELECT SUM(city.population) FROM city INNER JOIN country ON city.countrycode = country.code WHERE country.continent LIKE '%sia';