Hello coders, today we are going to solve Japan Population HackerRank Solution in SQL.
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:
Solution – Japan Population in SQL
select sum(population) from city where countrycode='JPN';
Disclaimer: The above Problem (Japan Population) is generated by Hacker Rank but the Solution is Provided by CodingBroz. This tutorial is only for Educational and Learning Purpose.