Prepare > SQL > Aggregation > Japan Population
2023. 5. 16. 20:34ㆍHackerRank-My SQL
Japan Population | HackerRank
Query to the sum of the populations of all Japanese cities in CITY.
www.hackerrank.com
문제
Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is JP.
코드
SELECT SUM(POPULATION) FROM CITY
WHERE COUNTRYCODE= 'JPN';
두 번째 시도
SELECT SUM(POPULATION) FROM CITY
WHERE COUNTRYCODE = 'JPN';
'HackerRank-My SQL' 카테고리의 다른 글
Prepare > SQL > Aggregation > The Blunder (0) | 2023.05.16 |
---|---|
Prepare > SQL > Aggregation > Population Density Difference (0) | 2023.05.16 |
Prepare > SQL > Aggregation > Average Population (0) | 2023.05.16 |
Prepare > SQL > Advanced Select > Occupations (0) | 2023.05.16 |
Prepare > SQL > Advanced Select > The PADS (0) | 2023.05.16 |