[해커랭크/SQL] 5. Japanese Cities' Names

👉https://www.hackerrank.com/challenges/japanese-cities-name/problem?isFullScreen=true

Japanese Cities' Names | HackerRank

---

🤔 문제 분석

1) Query the names of all the Japanese cities in the CITY table.

2) The COUNTRYCODE for Japan is JPN.

 

💡 풀이

SELECT NAME
FROM CITY
WHERE COUNTRYCODE = "JPN"