|
1
2
3
4
|
select city.name
from city
join country on city.countrycode=country.code
where country.continent='Africa'
|
cs |
반응형
'SQL' 카테고리의 다른 글
| Hackerrank Revising Aggregations - The Sum Function (0) | 2021.10.21 |
|---|---|
| Hacker rank Revising Aggregations - The Count Function (0) | 2021.10.21 |
| Hacker rank Population Census (0) | 2021.10.21 |
| Hacker rank Employee Salaries (0) | 2021.10.21 |
| Hacker rank Employee Names (0) | 2021.10.21 |
댓글