29 - Code Required - The population of people, people living in cities, and people not living in cities in each continent.

[Antonia2206]

As a market researcher I need to know the population of people, people living in cities, and people not living in cities in each continent for future advertising opportunities

SELECT A.Name AS cityname, B.Name AS countryname, B.Continent, A.Population FROM city A LEFT JOIN country B ON A.CountryCode = B.Code;