본문 바로가기

Programming/SQL

[HackerRank] Basic Join :Population Census (MySQL)

1. 문제 설명

문제 링크

2. 코드

SELECT SUM(C.POPULATION)
FROM CITY AS C
JOIN COUNTRY AS O ON C.CountryCode = O.Code
WHERE O.CONTINENT = 'Asia';