[HackerRank] MySQL - Japanese Cities' Attributes

문제

 

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

The CITY table is described as follows:

 

 

 

풀이

 

select * from city where countrycode = 'JPN';