코딩테스트/해커랭크 SQL
[해커랭크/SQL] 26. Japan Population
Sooyoon Jeong
2023. 3. 7. 13:51
🤔 문제 분석
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"