[hackerrank] Japanese Cities' Names

[hackerrank] Prepare > SQL > Basic Select >  Japanese Cities' Names

 

[문제]

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

 

[MYSQL]

 

 

[ORCALE]

select name
from city
where countrycode = 'JPN';