Japanese Cities' Attributes¶
Tags: Easy
Links: https://www.hackerrank.com/challenges/japanese-cities-attributes/problem
Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN
.
Input Format
The CITY table is described as follows:
SELECT *
FROM city
WHERE countrycode = 'JPN';