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.