Japanese Cities' Names¶
Tags: Easy
Links: https://www.hackerrank.com/challenges/japanese-cities-name/problem
Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN
.
Input Format
The CITY table is described as follows:
SELECT name
FROM city
WHERE countrycode = 'JPN';