Japanese Cities' Attributes

MySQL

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

The CITY table is described as follows:

Field

Type

ID

INT(11)

NAME

CHAR(35)

COUNTRYCODE

CHAR(3)

DISTRICT

CHAR(20)

POPULATION

INT(11)

Your Logic: