Asian Population

  1. select sum(city.population)  
  2. from city  
  3. inner join country on city.countrycode=country.code  
  4. where country.continent='Asia'  
Share:

0 Comments:

Post a Comment