[MySQL/HackerRank] Japanese Cities' Names

Question

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:

My Answer

SELECT NAME
FROM CITY
WHERE COUNTRYCODE = 'JPN';

Result

출처 : https://www.hackerrank.com/challenges/japanese-cities-name/problem

Japanese Cities' Names | HackerRank