HackerRank - Japanese Cities' Attributes

Problem:

Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.

The CITY table is described as follows:

# Solution

            
    SELECT *
    FROM CITY
    WHERE COUNTRYCODE = 'JPN';
        

Post:

• 2025-04 - Japanese Cities' Names;