[MySQL] Japanese Cities' Names

 SQL  >  Basic Select  > 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:

 

 My Answer 

SELECT NAME
FROM CITY
WHERE COUNTRYCODE = 'JPN'