** With using Join **

select sum(city.population) from city JOIN country on country.code = city.countrycode where country.continent='Asia';

** Without using Join **

select sum(city.population) from city, country where country.continent='Asia' and city.countrycode = country.code;