Hackerrank - Japan Population solution

Problem link

Solution one:

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