관리 메뉴

TEAM EDA

[HackerRank] Basic Select : Japanese Cities' Attributes 본문

EDA Study/SQL

[HackerRank] Basic Select : Japanese Cities' Attributes

김현우 2021. 2. 7. 21:17

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

The CITY table is described as follows:

SELECT * FROM CITY
    WHERE COUNTRYCODE = 'JPN';