Japanese Cities’ Attributes in SQL | HackerRank Solution

Hello coders, today we are going to solve Japanese Cities’ Attributes HackerRank Solution in SQL.

Problem

Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.

The CITY table is described as follows:

CITY

Field	Type
ID	NUMBER
NAME	VARCHAR2(17)
COUNTRYCODE	VARCHAR2(3)
DISTRICT	VARCHAR2(20)
POPULATION	NUMBER

Solution – Japanese Cities’ Attributes in SQL

SELECT * FROM CITY WHERE COUNTRYCODE = "JPN";

Disclaimer: The above Problem (Japanese Cities’ Attributes) is generated by Hacker Rank but the Solution is Provided by CodingBroz. This tutorial is only for Educational and Learning Purpose.