Japan Population HackerRankl Solution In MYSQL

Problem:-

Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is JPN.

Input Format

The CITY table is described as follows:

Solution:-

select sum(population)
from city

where countrycode="JPN"