HackerRank - Japanese Cities' Names

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:

• 2025-04 - Weather Observation Station 1;