Japanese Cities’ Names query in SQL Hacker Rank Solution

Hello coders, In this post, you will learn how to solve the Japanese Cities‘ Names query in SQL Hacker Rank Solution. This problem is a part of the SQL Hacker Rank series.

Problem

Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN.
The CITY table is described as follows:

Japanese Cities’ Names query in SQL Hacker Rank Solution

select Name from City where CountryCode ='JPN';

Disclaimer: The above Problem (Japanese Cities’ Names query in SQL) generated by Hackerrank but the Solution is Provided by Chase2Learn. This tutorial is only for Educational and Learning purposes.