[해커랭크/SQL] 26. Japan Population

👉 https://www.hackerrank.com/challenges/japan-population/problem?isFullScreen=true&h_r=next-challenge&h_v=zen

Japan Population | HackerRank

 

---

 

🤔 문제 분석

1) Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is JPN.

 

💡 풀이

SELECT SUM(POPULATION)
FROM CITY
WHERE COUNTRYCODE = "JPN"