Japanese Cities' Names - SELECT the name column
Author: Al-mamun Sarkar
Date: 2020-03-26 15:27:43
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';