관리 메뉴

TEAM EDA

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

EDA Study/SQL

[HackerRank] Basic Select : Japanese Cities' Names

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

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:

SELECT NAME FROM CITY
    WHERE COUNTRYCODE = 'JPN';