You are viewing a single comment's thread. Return to all comments →
Method 1: SELECT SUM(C.Population) AS Total_Population FROM City C JOIN Country CO ON C.CountryCode = CO.Code WHERE CO.Continent = 'Asia';
Method 2: SELECT SUM(C.Population) AS Total_Population FROM City C INNER JOIN Country CO ON C.CountryCode = CO.Code WHERE CO.Continent = 'Asia';
Seems like cookies are disabled on this browser, please enable them to open this website
Population Census
You are viewing a single comment's thread. Return to all comments →
MySQL
Method 1: SELECT SUM(C.Population) AS Total_Population FROM City C JOIN Country CO ON C.CountryCode = CO.Code WHERE CO.Continent = 'Asia';
Method 2: SELECT SUM(C.Population) AS Total_Population FROM City C INNER JOIN Country CO ON C.CountryCode = CO.Code WHERE CO.Continent = 'Asia';