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

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

Input Format

The CITY table is described as follows:
 

My SQL query: 

SELECT name from CITY where COUNTRYCODE= 'JPN';