[hackerrank] Japanese Cities' Attributes

[hackerrank] Prepare > SQL > Basic Select >  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:

 

[MYSQL]

 

 

[ORCALE]

select *
from city
where countrycode = 'JPN';