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
|
1333 Discussions
|
Please Login in order to post a comment
my sql select sum(c1.population) from city c1 inner join country c2 on c1.countrycode = c2.code where c2.continent = 'Asia';
Select sum(ct.population) from city ct inner join country c on ct.countrycode=c.code where c.continent='Asia'
SELECT SUM(CITY.POPULATION) FROM CITY
JOIN COUNTRY ON CITY.COUNTRYCODE=COUNTRY.CODE WHERE CONTINENT="ASIA"
select sum(city.population) from city join country on city.countrycode=country.code where continent='Asia';
SQL Server