Japanese Cities' Attributes

SQL Select Query - Select all columns. Show all columns of the JPN from the city table. This is the solution of the HackerRank Japanese Cities' Attributes SQL problem.

 

Table Name: CITY 

Table structure:

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

 

SQL Query:

SELECT * FROM CITY
WHERE COUNTRYCODE = 'JPN';