Japanese Cities’ Attributes in SQL | HackerRank Solution

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

Japanese Cities' Attributes 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

FieldType
IDNUMBER
NAMEVARCHAR2(17)
COUNTRYCODEVARCHAR2(3)
DISTRICTVARCHAR2(20)
POPULATIONNUMBER

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.

Leave a Comment

Your email address will not be published.