Query the names of all the Japanese cities in the CITY table

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:

 

 

———-SOLUTION———-

 

SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN'; 

You may also like...

Leave a Reply

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