We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Basic Select
  4. Japanese Cities' Names
  5. Discussions

Japanese Cities' Names

  • karanvikram007
     + 0 comments

    Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN.

    To query just the names of all Japanese cities from the CITY table, where the COUNTRYCODE for Japan is 'JPN', you can use the following SQL query:

    SELECT NAME
FROM CITY
WHERE CountryCode = 'JPN';

    In this query: - SELECT NAME specifies that you only want to retrieve the NAME field from the CITY table. - FROM CITY indicates the table from which you are querying. - The WHERE CountryCode = 'JPN' clause filters the results to include only cities that have the country code 'JPN', which corresponds to Japan.