SELECT
    ID,
    NAME,
    DISTRICT,
    POPULATION,
    COUNTRYCODE
FROM CITY
WHERE
    COUNTRYCODE = 'JPN'