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 – Hacker Rank Solution
SELECT SUM(POPULATION) FROM CITY WHERE COUNTRYCODE = 'JPN';
Disclaimer: The above Problem (Japan Population) generated by Hackerrank but the Solution is Provided by Chase2Learn. This tutorial is only for Educational and Learning purposes. Authority if any of the queries regarding this post or website fill the following contact form thank you.