HackerRank MySQL - Japan Population
Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is JPN.
- SELECT SUM(POPULATION)
- FROM CITY
- WHERE COUNTRYCODE = 'JPN';
Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is JPN.
- SELECT SUM(POPULATION)
- FROM CITY
- WHERE COUNTRYCODE = 'JPN';