문제
Query the total population of all cities in CITY where District is California.
Input Format
The CITY table is described as follows:
코드
SELECT SUM(population)
FROM city
WHERE district = 'California'
출처
반응형
'Algorithm > MySQL' 카테고리의 다른 글
[해커랭크(Hacker Rank)]Average Population (MySQL) (0) | 2021.06.30 |
---|---|
[해커랭크(Hacker Rank)]Revising Aggregations - The Count Function (MySQL) (0) | 2021.06.30 |
[해커랭크(Hacker Rank)] Revising Aggregations - Averages (MySQL) (0) | 2021.06.30 |
[프로그래머스] 보호소에서 중성화한 동물 (MySQL) (0) | 2021.06.29 |
[프로그래머스] 오랜 기간 보호한 동물(1) (MySQL) (0) | 2021.06.29 |