순간을 기록으로

[MySQL] African Cities | Join 본문

Problem Solving

[MySQL] African Cities | Join

luminous13 2022. 4. 6. 14:50

문제

 

- 모든 시티의 이름들을 조회하세요

-조건1: continent is 'africa'

-조건2: city.countrycode = country.code 

 

풀이

select CITY.name
from CITY 
join COUNTRY 
on CITY.countryCode = COUNTRY.code
where COUNTRY.continent = 'Africa';

 

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

[MySQL] The Report  (0) 2022.04.06
[MySQL] Average Population of Each Continent | Join  (0) 2022.04.06
[MySQL] Population Census | Join  (0) 2022.04.06
[MySQL] Weather Observation Station 17  (0) 2022.04.06
[MySQL] Weather Observation Station 16  (0) 2022.04.06
'Problem Solving' Related Articles more
Comments