African Cities

  • + 0 comments

    The important learning here is about JOIN

    SELECT city.name
    FROM city
    JOIN country ON city.countrycode = country.code
    WHERE continent = 'Africa';