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

2021년 7월 31일 (토) 10:48 기준 최신판

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

@@ 1번째 줄: / 1번째 줄: @@
 ==개요==
 ;HR-SQL African Cities
-*
+* https://www.hackerrank.com/challenges/african-cities/problem
 {{HR-SQL 헤더}}
@@ 7번째 줄: / 7번째 줄: @@
 |}
-<source lang='sql'>
+==MySQL==
-</source>
+<syntaxhighlight lang='mysql'>
+SELECT CITY.Name
+FROM CITY, COUNTRY
+WHERE COUNTRY.Code = CITY.CountryCode
+AND COUNTRY.Continent = 'Africa';
+</syntaxhighlight>
+<syntaxhighlight lang='mysql'>
+SELECT CITY.Name
+FROM CITY
+JOIN COUNTRY ON COUNTRY.Code = CITY.CountryCode
+WHERE COUNTRY.Continent = 'Africa';
+</syntaxhighlight>