✅ Japan Population
📝 문제
Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is JPN.
Input Format
The CITY table is described as follows:
💻 풀이
SELECT SUM(POPULATION)
FROM CITY
WHERE COUNTRYCODE = 'JPN';Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is JPN.
Input Format
The CITY table is described as follows:
SELECT SUM(POPULATION)
FROM CITY
WHERE COUNTRYCODE = 'JPN';