Im between cherry

Hackerrank | MySQL | African Cities 본문

데이터분석/practice_query

Hackerrank | MySQL | African Cities

meal 2020. 8. 29. 15:45

African Cities

Problem

 

African Cities | HackerRank

Query the names of all cities on the continent 'Africa'.

www.hackerrank.com

 

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.

 

 

SELECT City.Name
FROM City
LEFT JOIN Country ON City.Countrycode = Country.Code
WHERE Country.Continent = 'Africa'
저작자표시

'데이터분석 > practice_query' 카테고리의 다른 글

Hackerrank | MySQL | Draw The Triangle 1  (0) 2020.08.29
Hackerrank | MySQL | Average Population of Each Continent  (0) 2020.08.29
Hackerrank | MySQL | Asian Population  (0) 2020.08.29
Hackerrank | MySQL | Weather Observation Station 17  (0) 2020.08.29
Hackerrank | MySQL | Weather Observation Station 16  (0) 2020.08.29
'데이터분석/practice_query' Related Articles more
Comments