Hello coders, In this post, you will learn how to solve the Japan Population sql Hacker Rank Solution. This problem is a part of the SQL Hacker Rank series.
Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is JPN.
The CITY table is described as follows:
Japan Population SQL Hacker Rank Solution
SELECT SUM(POPULATION) FROM CITY WHERE COUNTRYCODE = 'JPN';