HackerRank-Aggregation-Japan Population

Japan Population

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:

My solution

SELECT SUM(POPULATION)
FROM CITY
WHERE COUNTRYCODE = 'JPN';