[MySQL/HackerRank] Japanese Cities' Names

https://www.hackerrank.com/challenges/japanese-cities-name/problem?isFullScreen=true 

Japanese Cities' Names | HackerRank

문제

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:

Code

SELECT NAME
FROM CITY
WHERE COUNTRYCODE = 'JPN'