Japanese Cities' Attributes

January 17, 2024

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

The CITY table is described as follows:

SELECT * FROM CITY WHERE COUNTRYCODE = 'JPN';