Japanese Cities’ Names HackerRank Solution SQL

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:

SOURCE: HackerRank.com

Japanese Cities’ Names HackerRank Solution SQL

SELECT Name FROM City WHERE CountryCode = 'JPN';

Attempt – https://www.hackerrank.com/challenges/japanese-cities-name

Leave a Comment