Query all attributes of every Japanese city in the CITY table

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

The CITY table is described as follows:

 

———-SOLUTION———

 

SELECT * FROM CITY WHERE COUNTRYCODE = 'JPN'; 

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *