HackerRank MySQL - Asian Population



Given the CITY and COUNTRY tables, query the sum of the populations of all cities where the CONTINENT is 'Asia'.



  1. SELECT SUM(CITY.POPULATION)
  2. FROM CITY
  3. JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE
  4. WHERE COUNTRY.CONTINENT = 'Asia';

download android app