BASIC SELECT
Last updated 1 year ago
Question Link
Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.
JPN
The CITY table is described as follows:
SELECT * FROM City WHERE countrycode = 'JPN'