The population living differences of each country

[rosshardie]

As a user I want to be able to see the population of people living in cities, and people not living in cities of each country

[Amckenzie93]

Population Report For the population reports, the following information is requested:

• The name of the continent/region/country.
• The total population of the continent/region/country.
• The total population of the continent/region/country living in cities (including a %).
• The total population of the continent/region/country not living in cities (including a %).

[Causeless]

SELECT 
    country.Name 
        AS 'Country', 
    country.Population
        AS 'Total Population', 
    SUM(city.Population) 
        AS 'Population Living in Cities',
    (SUM(city.Population) / country.Population) * 100 
        AS 'Population Living in Cities (%)',
    country.Population - SUM(city.Population) 
        AS 'Population Not Living in Cities',
    ((country.Population - SUM(city.Population)) / country.Population) * 100 
        AS 'Population Not Living in Cities (%)'
FROM country
JOIN city ON city.CountryCode = country.Code
WHERE country.name LIKE 'Aruba' -- where clause taken from user input
GROUP BY country.Name, country.Population