Problem Name: Sql -
In this HackerRank Functions in SQL problem solution,
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:
#1 Code Example with SQL
Copy The Code & Try With Live Editor
SELECT SUM(POPULATION) FROM CITY WHERE COUNTRYCODE = 'JPN';