코딩코딩코딩

[HackerRank] Average Population of Each Continent 본문

MySQL/Problem Solving

[HackerRank] Average Population of Each Continent

hanshow113 2022. 2. 6. 19:52

 

SELECT COUNTRY.Continent
     , FLOOR(AVG(CITY.population))
FROM CITY
     INNER JOIN COUNTRY ON CITY.CountryCode = COUNTRY.CODE
GROUP BY COUNTRY.Continent

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

[LeetCode] 183. Customers Who Never Order  (2) 2022.02.06
[HackerRank] African Cities  (0) 2022.02.06
[HackerRank] Population Census  (0) 2022.02.06
[LeetCode] 1179.Reformat Department Table, MySQL 피봇테이블  (0) 2022.02.06
[HackerRank] Type of Triangle  (0) 2022.01.18
'MySQL/Problem Solving' Related Articles more
Comments