[HackerRank] Japanese Cities' Names SQL

@notepad_jj2

츄르사려고 코딩하는집사입니다.

---

1. [HackerRank] Japanese Cities' Names SQL

 

2. 문제 출처

https://www.hackerrank.com/challenges/japanese-cities-name/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen 

Japanese Cities' Names | HackerRank

 

3. 문제

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:

 

4. 소스 코드

SELECT NAME
FROM CITY
WHERE COUNTRYCODE = 'JPN';

 

---