We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Aggregation
  4. Japan Population

Japan Population

HackerRank

|
  1. Prepare
  2. SQL
  3. Aggregation
  4. Japan Population
Exit Full Screen View

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: