Japan Population
- URL : https://www.hackerrank.com/challenges/japan-population/problem
- Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is JPN.
- MySQL, Oracle Solution
1
2
3
select sum(population)
from city
where countrycode = 'JPN';