Query the details for all the Japanese cities in CITY. The COUNTRYCODE for Japan is JPN.

Query the details for all the Japanese cities in CITY. The COUNTRYCODE for Japan is JPN.

Input Format

The CITY table is described as follows:

SOLUTION:

      We have to write a query that gives list of the cities with country code as jpn.Query is as follows

   

                 SELECT * FROM CITY WHERE COUNTRYCODE='JPN';