We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
- Prepare
- SQL
- Basic Join
- Population Census
- Discussions
Population Census
Population Census
Sort by
recency
|
1507 Discussions
|
Please Login in order to post a comment
SELECT sum(c.population) FROM CITY C INNER JOIN COUNTRY CT ON C.COUNTRYCODE = CT.CODE AND CT.CONTINENT = 'Asia'
sql SELECT SUM(C.Population) FROM CITY C INNER JOIN COUNTRY CO ON C.CountryCode = CO.Code WHERE CO.Continent = 'Asia';
select sum(ct.population) from city ct join country cr on ct.countrycode=cr.code where cr.continent='Asia';
SELECT SUM(CITY.population) FROM CITY JOIN COUNTRY ON CITY.CountryCode = COUNTRY.Code WHERE COUNTRY.Continent ='Asia'