https://www.hackerrank.com/challenges/african-cities/problem?isFullScreen=true
African Cities | HackerRank
Query the names of all cities on the continent 'Africa'.
www.hackerrank.com
SELECT city.name
FROM city
INNER JOIN country ON city.countrycode = country.code
WHERE country.continent = 'Africa'
'Algorithm & SQL > HackerRank' 카테고리의 다른 글
| [HackerRank / MySQL] Type of Triangle (0) | 2024.03.10 |
|---|---|
| [HackerRank / MySQL] Top Earners (0) | 2024.03.10 |
| [HackerRank / MySQL] Revising Aggregations - Averages (0) | 2024.03.10 |
| [HackerRank / MySQL] Weather Observation Station 15 (0) | 2024.03.09 |
| [HackerRank / MySQL] Higher Than 75 Marks (0) | 2024.03.09 |
