[SQL][HackerRank] Higher Than 75 Marks

https://www.hackerrank.com/challenges/japan-population/problem

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:

      

      

      

    
    

      <sql />
    
SELECT SUM(POPULATION)
FROM CITY
WHERE COUNTRYCODE = 'JPN';