https://www.hackerrank.com/challenges/japan-population/problem
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';
'Algorithm > SQL' 카테고리의 다른 글
[SQL][HackerRank] Population Density Difference (0) | 2020.06.11 |
---|---|
[SQL][HackerRank] Population Density Difference (0) | 2020.06.11 |
[SQL][HackerRank] Average Population (0) | 2020.06.11 |
[SQL][HackerRank] Revising Aggregations - Averages (0) | 2020.06.11 |
[SQL][HackerRank] Revising Aggregations - The Sum Function (0) | 2020.06.11 |