Hackerrank - Japan Population solution

Solution one:

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