코딩코딩코딩

[HackerRank] Population Census 본문

MySQL/Problem Solving

[HackerRank] Population Census

hanshow113 2022. 2. 6. 19:35

 

LEFT JOIN

SELECT SUM(CITY.population)
FROM CITY
     INNER JOIN COUNTRY ON CITY.CountryCode = COUNTRY.CODE
WHERE COUNTRY.CONTINENT = 'Asia'

'MySQL > Problem Solving' 카테고리의 다른 글

[HackerRank] Average Population of Each Continent  (0) 2022.02.06
[HackerRank] African Cities  (0) 2022.02.06
[LeetCode] 1179.Reformat Department Table, MySQL 피봇테이블  (0) 2022.02.06
[HackerRank] Type of Triangle  (0) 2022.01.18
[HackerRank] Top Earners  (0) 2022.01.12
'MySQL/Problem Solving' Related Articles more
Comments