HackerRank - Japanese Cities' Names

April - 25/2025

Problem:

Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN.

The CITY table is described as follows:

# Solution

            
    SELECT NAME
    FROM CITY
    WHERE COUNTRYCODE = 'JPN';
        

Post: