Japanese Cities' Names - SELECT the name column

SQL Select Query - Select the name column. Show the name column of the JPN from the city table. This is the solution to the HackerRank Japanese Cities' Names SQL problem.

 

Table Name: CITY 

Table structure:

Field	Type
ID	NUMBER
NAME	VARCHAR
COUNTRYCODE	VARCHAR
DISTRICT	VARCHAR
POPULATION	NUMBER

 

SQL Query:

SELECT NAME FROM CITY
WHERE COUNTRYCODE = 'JPN';