[MySQL/HackerRank] Japanese Cities' Attributes

Question

Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.
The CITY table is described as follows:

My Answer

SELECT * 
FROM CITY
WHERE COUNTRYCODE = 'JPN';

Result

 

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

Japanese Cities' Attributes | HackerRank