|
1
2
3
4
5
|
select sum(city.population)
from city
join country on city.countrycode=country.code
where
country.continent='Asia'
|
cs |
반응형
'SQL' 카테고리의 다른 글
| Hacker rank Revising Aggregations - The Count Function (0) | 2021.10.21 |
|---|---|
| Hacker rank African Cities (0) | 2021.10.21 |
| Hacker rank Employee Salaries (0) | 2021.10.21 |
| Hacker rank Employee Names (0) | 2021.10.21 |
| Hacker rank Higher Than 75 Marks (0) | 2021.10.21 |
댓글