Japanese Cities' Attributes
Author: Al-mamun Sarkar
Date: 2020-03-26 15:12:16
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';