Japanese Cities' Attributes
Last updated
Last updated
Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.
The CITY table is described as follows:
Solution:
SELECT * FROM CITY WHERE COUNTRYCODE = "JPN";
Explanation:
SELECT *: This part of the query indicates that we want to retrieve all columns from 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.
