Japanese Cities' Names
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";
Explanation:
SELECT NAME: This part of the query indicates that we want to retrieve only the values in the NAME column of the CITY table.
FROM CITY: This specifies the table from which we want to retrieve the data, which is the CITY table.
WHERE COUNTRYCODE = "JPN": This is a condition added to the query using the WHERE clause. It filters the rows in the CITY table so that only rows where the value in the COUNTRYCODE column is "JPN" are included in the result.
Last updated