Japanese Cities' Attributes
Problem
Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.
Solution
SELECT *
FROM CITY
WHERE COUNTRYCODE = 'JPN'Japanese Cities' Names
Problem
Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN.
Solution
SELECT NAME
FROM CITY
WHERE COUNTRYCODE = 'JPN'