Решение SQL задания "Average Population of Each Continent" на HackerRank.com
Вставка
- Опубліковано 8 жов 2023
- СУБД: Oracle
Задание: Given the CITY and COUNTRY tables, query the names of all the continents (COUNTRY.Continent) and their respective average city populations (CITY.Population) rounded down to the nearest integer. Note: CITY.CountryCode and COUNTRY.Code are matching key columns.