[EASY] Japanese Cities' Names

 

Japanese Cities' Names | HackerRank

문제 조건

Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN.

 

문제 풀이 

select name
from city
where countrycode = 'JPN'