Hacker Rank SQL

African Cities Solution

Hello Friends in this article i am gone to share Hacker Rank SQL Solutions with you | African Cities Solution


Also Visit: Population Census Solution


 

Problem

Given theย CITYย andย COUNTRYย tables, query the names of all cities where theย CONTINENTย isย โ€˜Africaโ€™.

Note:ย CITY.CountryCodeย andย COUNTRY.Codeย are matching key columns.

Input Format

Theย CITYย andย COUNTRYย tables are described as follows:

Field Type
ID NUMBER
NAME VARCHAR2(17)
COUNTRYCODE VARCHAR2(3)
DISTRICT VARCHAR2(20)
POPULATION NUMBER
Field Type
CODE VARCHAR2(3)
NAME VARCHAR2(44)
CONTINENT VARCHAR2(13)
REGION VARCHAR2(25)
SURFACEAREA NUMBER
INDEPYEAR VARCHAR2(5)
POPULATION NUMBER
LIFEEXPECTANCY VARCHAR2(4)
GNP NUMBER
GNPOLD VARCHAR2(9)
LOCALNAME VARCHAR2(44)
GOVERNMENTFORM VARCHAR2(44)
HEADOFSTATE VARCHAR2(32)
CAPITAL VARCHAR2(4)
CODE2 VARCHAR2(2)

 

Solution โ€“ African Cities

MySQL Code
select city.name from city, country 
where city.countrycode = country.code 
and country.continent='Africa';

 

 

Disclaimer: The above Problems are generated by Hacker Rank but the Solutions are Provided by NYANDER.COM. All Hacker Rank SQL Solutions Shared only for Educational and Learning Purpose.