[MySQL/HackerRank] Japan Population

https://www.hackerrank.com/challenges/japan-population/problem?isFullScreen=true 

Japan Population | HackerRank

문제

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: 

Code

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