A. Continent_summary_view: Create a view to display each continent name, the number of countries in the continent, the total surface areas, and the total populations.

B. Population_view: Create a view to display each country name, country populations, the largest city populations of the country. Only North and South America countries are listed

TABLE City (ID, Name, CountryCode, District, Population, PRIMARY KEY (ID)) TABLE Country (Code, Name, Continent, Region, SurfaceArea, IndepYear small, Population, Life Expectancy, GNP, GNPOld, LocalName, GovernmentForm, HeadOfState, Capital, Code2, PRIMARY KEY (Code)) TABLE Country Language (CountryCode, Language, IsOfficial, Percentage, PRIMARY KEY (CountryCode, Language))