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

👉https://www.hackerrank.com/challenges/japanese-cities-attributes/problem

Japanese Cities' Attributes | HackerRank

---

🤔 문제 분석

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

 

💡 풀이

SELECT *
FROM CITY
WHERE COUNTRYCODE = "JPN"