Average Population of Each Continent in SQL | HackerRank Solution

Hello coders, today we are going to solve Average Population of Each Continent HackerRank Solution in SQL.

Average Population of Each Continent

Contents

Problem

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.

Input Format

The CITY and COUNTRY tables are described as follows:

FieldType
IDNUMBER
NAMEVARCHAR2(17)
COUNTRYCODEVARCHAR2(3)
DISTRICTVARCHAR2(20)
POPULATIONNUMBER
CITY
FieldType
CODEVARCHAR2(3)
NAMEVARCHAR2(44)
CONTINENTVARCHAR2(13)
REGIONVARCHAR2(25)
SURFACEAREANUMBER
INDEPYEARVARCHAR2(5)
POPULATIONNUMBER
LIFEEXPECTANCYVARCHAR2(4)
GNPNUMBER
GNPOLDVARCHAR2(9)
LOCALNAMEVARCHAR2(44)
GOVERNMENTFORMVARCHAR2(44)
HEADOFSTATEVARCHAR2(32)
CAPITALVARCHAR2(4)
CODE2VARCHAR2(2)
COUNTRY

Solution – Average Population of Each Continent in SQL

MySQL

select country.continent, floor(avg(city.population))
from country
join city on city.countrycode = country.code
group by country.continent;

Disclaimer: The above Problem (Average Population of Each Continent) is generated by Hacker Rank but the Solution is Provided by CodingBroz. This tutorial is only for Educational and Learning Purpose.

Leave a Comment

Your email address will not be published.