[해커랭크/SQL]Japanese Cities' Attributes

문제

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

문제해석 & 풀이

CITY테이블에서 COUNTRYCODE 가 JPN(JAPAN)인 것을 선택

SELECT * FROM CITY WHERE COUNTRYCODE = 'JPN'