"HR-SQL African Cities"의 두 판 사이의 차이

2018년 8월 16일 (목) 18:11 판

해커랭크 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

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

@@ 9번째 줄: / 9번째 줄: @@
 ==MySQL==
 <source lang='mysql'>
-SELECT CI.NAME FROM CITY AS CI, COUNTRY AS CO
+SELECT Name FROM CITY, COUNTRY
-WHERE CO.CODE = CI.COUNTRYCODE
+WHERE COUNTRY.Code = CITY.CountryCode
-AND CO.CONTINENT = 'Africa';
+AND COUNTRY.Continent = 'Africa';
 </source>