[SQL] (해커랭크) Japanese Cities' Attributes

Problem

HackerRank > Prepare > SQL > Basic Select > Japanese Cities' Attributes

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

The CITY table is described as follows:

Solution

SELECT *
FROM CITY
WHERE 1=1
and COUNTRYCODE = 'JPN'
;