[HackerRank] Population Census 오라클 풀이

mndev 2024. 2. 2. 13:38

문제링크

Population Census | HackerRank

Query the sum of the populations of all cities on the continent 'Asia'.

www.hackerrank.com

코드

select sum(a.population)
from city a join country b
on a.countrycode = b.code
where b.continent = 'Asia';