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
|
1281 Discussions
|
Please Login in order to post a comment
MS SQL SERVER
Here population is in both the tables so Why can't I simply take sum of population from country table?
Here population is in both the tables so Why can't I simply take sum of population from country table?
Select Sum(C1.Population) from CITY As C1 Inner Join COUNTRY As C2 ON C1.CountryCode = C2.Code where C2. CONTINENT ='ASIA'
Select Sum(C1.Population) from CITY As C1 Inner Join COUNTRY As C2 ON C1.CountryCode = C2.Code where C2. CONTINENT ='ASIA'