Tuesday, April 5, 2016

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';