🤔 문제 분석
1) Query the total population of all cities in CITY where District is California.
💡 풀이
SELECT SUM(POPULATION)
FROM CITY
WHERE DISTRICT = "California"
'코딩테스트 > 해커랭크 SQL' 카테고리의 다른 글
[해커랭크/SQL] 25. Average Population (0) | 2023.03.07 |
---|---|
[해커랭크/SQL] 24. Revising Aggregations - Averages (0) | 2023.03.06 |
[해커랭크/SQL] 22. Revising Aggregations - The Count Function (0) | 2023.03.06 |
[해커랭크/SQL] 20. Employee Salaries (0) | 2023.02.22 |
[해커랭크/SQL] 19. Employee Names (0) | 2023.02.22 |
댓글