[hackerrank] Japan Population

[hackerrank] Prepare > SQL > Aggregation > 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: 

 

[MYSQL]

 

 

[ORCALE]

 

select sum(population)
from city
where countrycode = 'JPN';