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
|
1391 Discussions
|
Please Login in order to post a comment
mySQL
select sum(C.population) from City as C inner join Country as E on C.CountryCode=E.Code where continent='Asia'
SELECT SUM(CITY.POPULATION) FROM CITY JOIN COUNTRY ON CITY.CountryCode = COUNTRY.Code WHERE COUNTRY.CONTINENT = 'Asia';
My sql
select
sum(c.POPULATION)as ans
from
CITY c join COUNTRY CO on c.COUNTRYCODE=CO.CODE
where
CO.CONTINENT='Asia'
Note that is a default inner join