[MySQL] Japanese Cities Attributes

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

 My Answer 

SELECT *
FROM CITY
WHERE COUNTRYCODE = 'JPN'