[EASY] Japanese Cities' Attributes

 

Japanese Cities' Attributes | HackerRank

 

문제 조건 

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

 

정답 쿼리

select *
from city
where countrycode = 'JPN'