SQL

HackerRank / Japanese Cities Attributes

K.Y.PARK 2022. 12. 8. 16:43

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'