HR-SQL African Cities

1 개요

HR-SQL African Cities

• https://www.hackerrank.com/challenges/african-cities/problem

해커랭크 SQL

문제	DB2	MS SQL	MySQL	Oracle
HR-SQL Basic Join e
HR-SQL Asian Population
HR-SQL African Cities
HR-SQL Average Population of Each Continent
HR-SQL The Report
HR-SQL Top Competitors
HR-SQL Ollivander's Inventory
HR-SQL Challenges
HR-SQL Contest Leaderboard

2 MySQL

SELECT CITY.Name FROM CITY, COUNTRY
WHERE COUNTRY.Code = CITY.CountryCode
AND COUNTRY.Continent = 'Africa';

SELECT CITY.Name
FROM CITY
JOIN COUNTRY ON COUNTRY.Code = CITY.CountryCode
WHERE COUNTRY.Continent = 'Africa';