코딩코딩코딩

[HackerRank] African Cities 본문

MySQL/Problem Solving

[HackerRank] African Cities

hanshow113 2022. 2. 6. 19:38 

SELECT CITY.NAME
FROM CITY
     INNER JOIN COUNTRY ON CITY.CountryCode = COUNTRY.Code
WHERE COUNTRY.CONTINENT = 'Africa'

'MySQL > Problem Solving' 카테고리의 다른 글

[LeetCode] 183. Customers Who Never Order  (2) 2022.02.06
[HackerRank] Average Population of Each Continent  (0) 2022.02.06
[HackerRank] Population Census  (0) 2022.02.06
[LeetCode] 1179.Reformat Department Table, MySQL 피봇테이블  (0) 2022.02.06
[HackerRank] Type of Triangle  (0) 2022.01.18
'MySQL/Problem Solving' Related Articles more
Comments