Japanese Cities’ Attributes HackerRank Solution SQL

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

The CITY table is described as follows:

SOURCE: HackerRank.com

 

Japanese Cities’ Attributes HackerRank Solution SQL

SELECT * FROM City WHERE CountryCode = 'JPN';

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

Leave a Comment